why is my code not outputting to an excel file? Can someone fix this? I get Warning: Unable to write to Excel format, attempting to write file to CSV format.

Hi when i load in my feature mat file it transposes them then exports to an excel file. I made an exccel file and ran the code. but the file is not exported. why? please fix this. Thanks.Here is the warning i get:

Warning: Unable to write to Excel format, attempting to write file to CSV format.

> In xlswrite (line 196)

% Load the feature mat file
load('feature6.mat');
% Initialize the output struct with empty arrays
outStruct = struct('avgSize', zeros(36,1), 'profileCounts', zeros(36,1), ...
    'zoneArea', zeros(36,1), 'totalArea', zeros(36,1), ...
    'AvgMinFeret', zeros(36,1), 'AvgFeret', zeros(36,1));
% Loop through each feature struct and concatenate the arrays for each field
for i = 1:3
    for j = 1:12
        % Concatenate the jth element of the current field from the current struct
        outStruct.avgSize((i-1)*12 + j) = features(i).avgSize(j);
        outStruct.profileCounts((i-1)*12 + j) = features(i).profileCounts(j);
        outStruct.zoneArea((i-1)*12 + j) = features(i).zoneArea(j);
        outStruct.totalArea((i-1)*12 + j) = features(i).totalArea(j);
        outStruct.AvgMinFeret((i-1)*12 + j) = features(i).AvgMinFeret(j);
        outStruct.AvgFeret((i-1)*12 + j) = features(i).AvgFeret(j);
    end
end
% Export the output struct to an Excel file
filename = 'outStruct.xlsx';
sheetname = 'Sheet1';
range = 'A1:F36';
fieldnames = {'avgSize', 'profileCounts', 'zoneArea', 'totalArea', 'AvgMinFeret', 'AvgFeret'};
% Write field names to the first row
xlswrite(filename, fieldnames, sheetname, 'A1:F1');
% Write data to the remaining rows
xlswrite(filename, [outStruct.avgSize, outStruct.profileCounts, outStruct.zoneArea, ...
    outStruct.totalArea, outStruct.AvgMinFeret, outStruct.AvgFeret], ...
    sheetname, range);

[Image Analyst]

Unfortunately you've delayed a response by forgetting to attach 'feature6.mat'.

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

[Torsten]

Maybe you don't have write permission to the directory.

Or what error message do you get ?

[Cris LaPierre]

Just a side note of the message you will see at the top of the xlswrite documentation page:

xlswrite is not recommended. Use writetable, writematrix, or writecell instead. For more information, see Compatibility Considerations.

[Chanille]

@Image Analyst Sorry about that! I have read the provided link, thanks. Also attached the mat file.

@Torsten i get: Warning: Unable to write to Excel format, attempting to write file to CSV format.

> In xlswrite (line 196)

@Cris LaPierre okay, I hope its that easy of a fix but in my previous experience it was not but thanks for the suggestion.

Answer 1

[Fangjun Jiang]

In terms of xlswrite(), your code is fine. I've tried it and it creates the file. You might want to change range='A2:F37'.

Try a simple example to see if your Excel app is able to write Excel file.

xlswrite('MyExl.xlsx',magic(5)); 
winopen('MyExl.xlsx');

[Chanille]

@Fangjun Jiang could it be because I am using the code on a mac? maybe when i have my windows computer i can try the code there and see if it creates the file for me now.

[Walter Roberson]

On Mac and Linux xlswrite cannot write xlsx files. Use writetable or writematrix

[Chanille]

@Walter Roberson I get the excel file in my current folder after running the code but I would like to export and open it in excel directly. So I added winopen(filename); but I get this error:

>> exportingdatatoexcel
Error using xlswrite
Error: The remote procedure call failed.


Error in exportingdatatoexcel (line 26)
xlswrite(filename, fieldnames, sheetname, 'A1:F1'); 

[Chanille]

@Fangjun Jiang Thanks!! You were correct and the example worked out well too.

[Walter Roberson]

winopen is not available on Mac

[Chanille]

This was in windows/dell. It did not work for me in Mac correct but on dell I got the above error when I tried to open the excel windows

[Chanille]

*window