Writetable does not allow me to have more than 32 columns in my table!
13 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
Walter Roberson
2017 年 9 月 13 日
>> 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.
回答 (1 件)
Fangjun Jiang
2017 年 9 月 13 日
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.
3 件のコメント
Image Analyst
2017 年 9 月 13 日
So simply upgrade your Excel. Can't you do that? If not, write to a csv file instead.
Fangjun Jiang
2017 年 9 月 14 日
Excel 2007 already has a column limit of 16384. Make sure you don't set the save option as "save to 97-2003 XLS format". Follow menu
File, Options, Save
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!