Skip to main content
T
tietjee15-Moonstone
15-Moonstone
October 18, 2012
Question

Write Excel Function

  • October 18, 2012
  • 1 reply
  • 5683 views

Prime 2.0 has the function WRITEEXCEL. This will write data to an Excel spreadsheet. The function does not have the flexibility of the MathCAD v15. MathCAD v15 will start the writing to a specified sheet and cell. Not having this feature reduces the ability to transfer data to a spreadsheet for pre and post processing. Does anybody have a work around for this issue?

1 reply

M
MikeArmstrong1-Visitor
1-Visitor
October 18, 2012

It's such a shame that they never included this, but I can't see a workaround without the use of scriptable objects. I can't understand how they managed to implement the feature in READEXCEL but nor WRITEEXCEL??

Mike

T
tselvan1-Visitor
1-Visitor
October 19, 2012

The functionality you are looking for is there in Prime 2 as well, only the syntax is changed(I think it is documented on the Migration guide). See screenshot below

WriteXL_test.png

Here 3 and 4 arguments represent starting row, col of dataset you want to write. So, 1,1 writes entire dataset.

M
MikeArmstrong1-Visitor
1-Visitor
October 19, 2012

Well done you are correct. I really need to start working on Prime a little more.

My on earth does it say you cannot do this in the help?

Mike

Terms & ConditionsAccessibility statement