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

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?

Answer 1

[Walter Roberson]

(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.

Answer 2

[Becky]

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!