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.

18 次查看（过去 30 天）

显示更早的评论

Chanille 2023-5-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1958634-why-is-my-code-not-outputting-to-an-excel-file-can-someone-fix-this-i-get-warning-unable-to-write

评论： Chanille 2023-5-8

采纳的回答： Fangjun Jiang

feature6.mat

在 MATLAB Online 中打开

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);

4 个评论
显示 2更早的评论隐藏 2更早的评论

Cris LaPierre 2023-5-5

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 2023-5-5

@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.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Fangjun Jiang 2023-5-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1958634-why-is-my-code-not-outputting-to-an-excel-file-can-someone-fix-this-i-get-warning-unable-to-write#answer_1230019

在 MATLAB Online 中打开

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');

7 个评论
显示 5更早的评论隐藏 5更早的评论

Chanille 2023-5-8

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 2023-5-8

*window

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by