MATLAB Answers

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

3 views (last 30 days)
Becky
Becky on 17 Nov 2011
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?

Accepted Answer

Walter Roberson
Walter Roberson on 17 Nov 2011
(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.

More Answers (1)

Becky
Becky on 17 Nov 2011
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!

Products

Community Treasure Hunt

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

Start Hunting!

Translated by