Skip to main content
M
MikeArmstrong1-Visitor
1-Visitor
September 4, 2010
Question

Mathcad 14 - Excel 2007 Bug

  • September 4, 2010
  • 1 reply
  • 4422 views

There have been a few threads recently asking similar questions about Mathcad 14 and Excel 2007 compatibility, so I have decided to make a thread about it.

It seems Embedded Excel 2007 components work within Mathcad 14, but the "Readfile" and "File Input" functions do not.

I have attached an image showing an example of the "File Input" function clearly displaying the error.

Both Excel files are saved on my desktop with exactly the same data, but the *.xlsx file does not read into Mathcad.

Has this bug been discussed before? Can anyone from PTC shed some light on this problem?

Mike

1 reply

M
mzeftel1-Visitor
1-Visitor
September 7, 2010

Mathcad 14 was developed before Excel 2007, so it does not support Excel 2007. Mathcad 15 does support Excel 2007, as will Prime 1.0.

Mona

J
jeanGiraud1-Visitor
1-Visitor
September 7, 2010

Mona Zeftel wrote:

Mathcad 14 was developed before Excel 2007, so it does not support Excel 2007. Mathcad 15 does support Excel 2007, as will Prime 1.0.

Mona

The matter is not mutual version compatibility. Whichever version Excel, and as long as you have columns of data, save the Excel as Text (Tab delimited), save in file for instance C:\File or in your Mathcad data file folder. Then in Mathcad READPRN("C:\File\[file name].txt)

MCADdata_0.gif

Note that READPRN reads the other Microsoft *.dat . These two types of data [*.txt &*.dat] are as old as Office 97 [maybe 3.1]. Why should Mathcad 14 not be capable of reading these two types of data ? Unless this is the bug !

jmG

Terms & ConditionsCookie settingsAccessibility statement