Currently, the size of a table/matrix which can be exported to a spreadsheet is limited to 255 columns X 65535 rows. I believe this rule was implemented because of the maximum possible size of a spreadsheet(Am I right?) . This used to be the case in Excel 2003, but since Excel 2007, a spreasheet  can be : 1,048,576 rows by 16,384 columns.

 

Maybe it is time to update this rule?

 

Excel 2003 :http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

 

Excel 2010 : http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291

 

Lovinash


Please Wait...