How to generate a .xls from a .mat using writexls

Question

David Stevens 2015-7-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231513-how-to-generate-a-xls-from-a-mat-using-writexls

评论： David Stevens 2015-7-29

Dears, I am working on a MatLab database. I have a function able to produce a '.mat' listing the different variables presents in the database while respecting their inter-relations. Practically, this '.mat' will inform me about the countries presents in the database and the data (variables) linked with each of them (scenario, categories, entities, and sources). When I try to convert the '.mat' to an '.xls', I use the following code: "data=load('report.mat'); xlswrite('report.xls','report.mat')" I might sound stupid but this code just literally write 'report.mat' on a xcel sheet. If anyone might be able to provide me helps it could be great! Thanks.

David

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2015-7-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231513-how-to-generate-a-xls-from-a-mat-using-writexls#answer_187560

在 MATLAB Online 中打开

Possibly

data = load('report.mat');
fn = fieldnames(data);
report_contents = struct2cell(data);
data_to_write = vertcat(fn(:).', report_contents(:).');
xlswrite('report.xls', data_to_write)

This tries to create one column per variable name in the .mat file, using the name of the variable as the column header.

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

David Stevens 2015-7-29

Hi Walter, thank you very much for your answer! it looks promising and helpful. Unfortunately it´s not really working, and I remain unclear why! I get a warning "ActiveX - invalid argument type or value", therefore I look to the class of the report typing "whos report" and obviously it´s a "struct". Then I don´t know why my output just keep on writing "report" on a excel sheet. Thank you for your help. David

请先登录，再进行评论。