xlswrite to import data from cell array

2 views (last 30 days)
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 Comments
Walter Roberson
Walter Roberson on 25 May 2018
Is there a particular reason you are not using writetable() to write those tables? You can pass 'Sheetname' to writetable()
Mudasser Seraj
Mudasser Seraj on 25 May 2018
Edited: Mudasser Seraj on 25 May 2018
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?

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 25 May 2018
filename = 'MySpreadsheet.xls';
for sheet = 1 : length(m)
writetable(m{sheet}, filename, 'sheet', sheet)'
end
  3 Comments
Walter Roberson
Walter Roberson on 26 May 2018
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 on 28 May 2018
Yeah. That worked perfectly. Thank you so much.

Sign in to comment.

More Answers (0)

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!