xlswrite to import data from cell array

2018 5 25
1 个回答
回答已采纳
更新时间：2018 5 28
12 次查看（30 天）

0 个投票

Hello,
I have a matrix 'm' with 373 cell. each containting 2-d matrix of different size. I want to use 'xlswrite' to write the contents of each table on different sheets of the same file. Can someone please help me in this regard?

2 个评论
显示 无 隐藏 无

Walter Roberson
Walter Roberson 2018-5-25
Is there a particular reason you are not using writetable() to write those tables? You can pass 'Sheetname' to writetable()
Mudasser Seraj
Mudasser Seraj 2018-5-25
编辑：Mudasser Seraj 2018-5-25
No, there's no particular reason. If I want to use writetable(), then what should be the code? Is it possible to write them as a sequence of sheets?

请先登录，再进行评论。

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

 采纳的回答

Walter Roberson
Walter Roberson 2018-5-25

0 个投票

filename = 'MySpreadsheet.xls';
for sheet = 1 : length(m)
writetable(m{sheet}, filename, 'sheet', sheet)'
end

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

Mudasser Seraj
Mudasser Seraj 2018-5-25
I am getting this error after a while:
"Error using writetable (line 124)
Unable to write to file 'MyDatabase.xlsx'. You may not have write permissions or the file may be open by another application."
Walter Roberson
Walter Roberson 2018-5-26
The first thing I would try would be to add a pause(5) after the writetable() to give the previous action time to finish.
Mudasser Seraj
Mudasser Seraj 2018-5-28
Yeah. That worked perfectly. Thank you so much.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by