Items tagged with spreadsheet spreadsheet Tagged Items Feed

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

Hey all,

My question is better explained with an example

the algorithm I have here creates a matrix M[j] for each run of j.

I want to be able to export each of these matrices to a different spreadsheet and if possible, set up a naming critiria for each spreadsheet(so that I dont have to enter a name in the dialog box after each run)

Any suggestion will be really appreciated. Thanks

Lovinash

here's the example:

The attached worksheet defines a procedure CircumStrain() which is supposed to create and populate a spreadsheet with the solutions of several equations.  The problem is that the spreadsheet Strain is never created.  Would someone please evaluate the worksheet and perhaps suggest a fix.  Your assistance is appreciated.

Wayne

View 4865_Chan McMinn B.mw on MapleNet