how can i read values from excel into mathcad
how can i read values from excel into mathcad
(OP)
Hi,
I´d like to use a mathcad-sheet in Excel for making some calculations.
I found the traject.xls on the mathsoft homepage. But this one only works fine with Excel 97 (german version). I´d like to use Excel 2003 (german version).
When I try the traject.xls in Excel 2003 with Mathcad 12 I got problems with floating point number.
Means:
I type 2,3 in the excel-worksheet and mathcad calculates with 23.
(But it works on Excel 97: typing 2,3 à calculating with 2.3)
Does anyone know this problem.. or maybe a solution?
Thanks
I´d like to use a mathcad-sheet in Excel for making some calculations.
I found the traject.xls on the mathsoft homepage. But this one only works fine with Excel 97 (german version). I´d like to use Excel 2003 (german version).
When I try the traject.xls in Excel 2003 with Mathcad 12 I got problems with floating point number.
Means:
I type 2,3 in the excel-worksheet and mathcad calculates with 23.
(But it works on Excel 97: typing 2,3 à calculating with 2.3)
Does anyone know this problem.. or maybe a solution?
Thanks





RE: how can i read values from excel into mathcad
Bung
Life is non-linear...
RE: how can i read values from excel into mathcad
There´s no problem with Excel 97 and Mathcad 8. There the comma is interpreted the right way.
It´s only when I use Excel 2003 and Mathcad 12.
*confused*
I think there have to be some settings I have to change… but I don´t know which.
Or did they change the OLE-Automation-Interface? Do you know something?
Thanks in advance
RE: how can i read values from excel into mathcad
You can find it in "Extras" - "Optionen" - "International" in Excel 2003! Set it to "point" for the separator and disable "Trennzeichen vom Betriebssystem übernehmen" Checkbox!
It is worth trying - good luck!
Andreas
(mail@waffentechnik.com)