write data to excel for more than 26 (A-Z) columns

2 次查看（过去 30 天）
Muhammad Usman
Muhammad Usman 2014-9-6
回答： Image Analyst 2014-9-6
I am using xlswrite and wants to write data ranging from A column to ABC column,but when i specify the range A:ABC,i got an error,please help me what should i do.
range = 'A':'ABC'
xlswrite([filename],[my_ftn],sheet1,range)
waiting for someone's reply

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

采纳的回答

Image Analyst
Image Analyst 2014-9-6
Don't specify the lower right cell, just the upper left, and it will put the whole thing in there:
xlswrite(fullFilename, hugeArray, 'My Results', 'A1');

更多回答（1 个）

Guillaume
Guillaume 2014-9-6
编辑：Guillaume 2014-9-6
Two things:
Your version of excel may be limited to 256 columns, i.e. you can only save range 'A:IV'.
You need to specify a row range as well, otherwise it's going to fill as many rows as excel can handle:
xlswrite(filename, my_ftn, sprintf('A1:BZ%d', size(my_ftn, 1))); %replace BZ by the proper column or calculate it

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by