Writetable does not allow me to have more than 32 columns in my table!

23 次查看（过去 30 天）

Milad Zarei 2017-9-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/356512-writetable-does-not-allow-me-to-have-more-than-32-columns-in-my-table

评论： Fangjun Jiang 2017-9-14

I am trying to export an Excel table using writetable commend, but it gives me this error:

Error using writetable (line 117)
The data block starting at cell 'A1' exceeds the sheet boundaries by 0 row(s) and 32 column(s).

Do you have any ideas how to fix this? Thanks :)

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

Walter Roberson 2017-9-13

在 MATLAB Online 中打开

>> filename = 'test.xlsx';
>> Tab1 = randn(101, 288);
   writetable(Tab1,filename,'sheet',1,'Range','A1')
Undefined function 'write' for input arguments of type 'double'.
Error in writetable (line 124)
write(a,filename,varargin{:}) 
>> Tab1 = table(Tab1)
Tab1 =
  101×1 table
         Tab1     
    ______________
    [1x288 double]
    [1x288 double]
    ...
>> writetable(Tab1,filename,'sheet',1,'Range','A1')
>>

This suggests that your test case is not an accurate reflection of your actual usage.

Walter Roberson 2017-9-14

What extension are you using for the file name?

请先登录，再进行评论。

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

回答（1 个）

Fangjun Jiang 2017-9-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/356512-writetable-does-not-allow-me-to-have-more-than-32-columns-in-my-table#answer_281443

You may have a quite old version of Microsoft Office, in which the Excel has a limit of 256 columns. Try some data with less number of columns to see if the error message still exists.