Excel column limit
is excel's columns limited to 256 ? i try to fill my excel file with a matrix of 1200 x 800 and it doesn't seem to work ( i recieve an error that states that any data开发者_Go百科 beyond the 256 column will not be saved ) . any ideas how this could be avoided ?
Regards, Alexandru Badescu
Older versions of Excel had a maximum of 256 columns. Excel 2007 increased the column limit to over 16000.
Nope, limits on worksheet size are way more than that - see here for program constraints (Excel 2007). Your problem must be elsewhere (or in Excel version being older).
1,048,576 rows by 16,384 columns
Upgrade to a higher version excel, you are using excel 2003 or earlier. 2010 and 2007 offer more columns.
精彩评论