Skip to main content
R
richardm551-Visitor
1-Visitor
March 12, 2018
Question

How many maximum rows can Mathcad 15 handle to read excell spreadsheet data?

  • March 12, 2018
  • 8 replies
  • 3895 views

I have Mathcad 15 and I wanted to use excell spreadsheet to show up the calculation results over it and also to use excell spreadsheet to read values typed in an excell table.

But I have noticed I can generate only maximum rows 65536 and it looks like Mathcad 15 handles the old version of Excell 2003.

Is it possible to do anything to use new version of Excell which can handle up to 1048576 rows and16384 columns?

 

Thank you for any help

8 replies

W
Werner_E25-Diamond I
25-Diamond I
March 12, 2018

did you try to use READEXCEL to import the data?

R
richardm551-VisitorAuthor
1-Visitor
March 12, 2018

No, I will try it tomorrow. Maybe good idea.

R
richardm551-VisitorAuthor
1-Visitor
March 13, 2018

READFILE function reads data form external file but I need the function which will work in an oppositve way.

I need to transfer data from Mathcad to excell file with no limitation I've faced.

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
March 13, 2018

Mathcad 15 has "data tables,"  Insert/data/table.  I don't know if there's a size limit or not. 

  • Insert a blank table
  • In EXCEL, copy the data you want
  • in Mathcad, right-click on the table, select "paste table"

Data is in the table (which you give a variable name) as an array variable.

R
richardm551-VisitorAuthor
1-Visitor
March 13, 2018

Yesterday  I found out that Mathcad 15 has some limitation to maximum number of rows and columns to proceed and looks like mathcad 15 can handle spreadsheets for Excel 2003 version which could do max 65 thousand rows.

Terms & ConditionsAccessibility statement