How to save multiple tables in seperate sheets in Excel

42 次查看（过去 30 天）

Victoria 2018-7-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/410278-how-to-save-multiple-tables-in-seperate-sheets-in-excel

评论： Benjamin Drewry 2019-12-2

Hello - I am running multiple files in MATLAB and would like to save the outputs from regionprops into one large Excel file. With my current code, which is below, it will only save as seperate .txt files. Help is appreciatied - thank you!

figure,imshow(BW);
stats = regionprops(BW,'MajorAxisLength');
t = struct2table(stats);
path = 'C:\Users\Test' ;
filename = [path, filesep, 'GFP',num2str(k)] ;
writetable(t,filename);
end

k stands for k=1:length(Files)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Benjamin Drewry 2019-12-2

Victoria,

Just use the writetable function with the name-value pair 'Sheet', number.

i.e. writetable(t, 'fName.xlsx', 'Sheet', 4);

Thanks,

Ben

请先登录，再进行评论。

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

回答（2 个）

Christopher Wallace 2018-7-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/410278-how-to-save-multiple-tables-in-seperate-sheets-in-excel#answer_328768

在 MATLAB Online 中打开

Hi Victoria,

Have you looked into the documentation for the Matlab command 'xlswrite' ?

https://www.mathworks.com/help/matlab/ref/xlswrite.html

You should be able to do something along the lines of:

xlswrite(filename, data, 'Sheet1')

But since the xlswrite function only accepts two-dimensional numeric, character array, or string array, or, if each cell contains a single element, a cell array, you'll have to reformat your data before putting it in.

If you'd like to add a new sheet just change the name of the sheet in the xlswrite parameters. If it the sheet doesn't exist it will be created.

Best Regards,

Chris