append/excel

Forum|Forum|11 years ago
September 27, 2014
4 replies
4305 views

Hello,

My program calculates several series of input data. I want to store all the outputs in an excel file. Is there similar function to "Appendprn" for excel file?

Thank you.

Statistics_Analysis

Best answer by Werner_E

Look at the attached sheet.

Guess it should do the job.

W

Werner_E

25-Diamond I

Lookup WRITEEXCEL in the hep.

M

MikeArmstrong

1-Visitor

As Werner said lookup WRITEEXCEL and there are also loads of scripted components in forum which have been developed which do similar.

That's if you are not using Prime.

W

Werner_E

25-Diamond I

WRITEEXCEL supports OpenXML (*.xlsx) files.

Depending on your needs WRITECSV might be an option, too.

P

payman

Author

1-Visitor

Thank you.

But it overwrites the previously calculated values.

W

Werner_E

25-Diamond I

PAYMAN RAJAI wrote:
Thank you.
But it overwrites the previously calculated values.

No, it doesn't. You decide where the data should be written. An Excel file is not a sequential data file, so there can't be that sort of append. You have to provide some sort of counter to be able to write the data at the correct position.

As an alternative you could read in the whole Excel file with READEXCEL in a Mathcad matrix, stack that matrix on top of the new data and write the new matrix with WRITEEXCEL at position A1.