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

1 vue (au cours des 30 derniers jours)
Becky
Becky le 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?

Réponse acceptée

Walter Roberson
Walter Roberson le 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.

Plus de réponses (1)

Becky
Becky le 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!

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by