Why do I get Excel error when using writetable command ?
Show older comments
Hi All
I have the TT parameter as :
[c1,hist,edges,rmm,idx] = rainflow(Z,t);
TT = array2table(c,'VariableNames',{'Count','Range','Mean','Start','End'});
While I have used to convert TT from a timetable to table with :
TT=timetable2table(TT);
I use the
writetable(TT,'output_file.xlsx'); % assumed filename "output_file "
but I get the error :
Error using writetable (line 124)
Unable to write to sheet '' in file 'Ystat.xlsx'. Disable sheet protection, disable workbook's Mark as Final
option, and ensure input does not exceed cell capacity.
TT1=array2table(TT);
writetable(TT1,name);
and I get :
Error using writetable (line 124)
Index exceeds matrix dimensions.
4 Comments
farzad
on 26 Dec 2019
Walter Roberson
on 26 Dec 2019
What is size(TT)?
farzad
on 27 Dec 2019
farzad
on 27 Dec 2019
Accepted Answer
More Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!