Matlab xlswrite and Excel 2007 / 2010 no 256 column limitation?

2011 11 17
2 个回答
回答已采纳
3 次查看（30 天）

1 个投票

With the newer versions of Excel (2007 & 2010) that output *.xlsx files, there is no longer a 256 column limitation.
Are there plan for MatWorks to upgrade xlswrite to support writing the newer .xlsx files and allow larger matrices to be output to Excel?

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

 采纳的回答

Walter Roberson
Walter Roberson 2011-11-17

0 个投票

(The newer column limit is 16384)
It is my understanding that xlswrite() currently supports .xlsx files and more than 256 columns, but only for MS Windows systems that have Excel installed.
Product development plans for extension of this facility to other systems should be addressed to MathWorks Sales; as is common in most software firms, developers are usually not permitted to talk about what is upcoming.

更多回答（1 个）

Becky
Becky 2011-11-17

0 个投票

I did a quick test of writing a 1000 column cell array to a file name with a *.xlsx extension using xlswrite. It does indeed work.
Thank you!

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by