Why do I get Excel error when using writetable command ?

6 次查看（过去 30 天）

显示更早的评论

farzad 2019-12-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498110-why-do-i-get-excel-error-when-using-writetable-command

评论： farzad 2019-12-27

采纳的回答： KALYAN ACHARJYA

在 MATLAB Online 中打开

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.

Then using here , I did

TT1=array2table(TT);
writetable(TT1,name);

and I get :

Error using writetable (line 124)
Index exceeds matrix dimensions.

4 个评论
显示 2更早的评论隐藏 2更早的评论

farzad 2019-12-27

dear Walter, I think I was over writing a previous paramter called the same as TT with the new one in my array2table command, so it was not the right format to be written on excel file, but I resolved the problem thank you

farzad 2019-12-27