Skip to main content
payman1-Visitor
1-Visitor
Sep 27, 2014 7:12 PM UTC
Solved

append/excel

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.

Werner_E
Werner_EAnswer
25-Diamond I
Sep 29, 2014 11:16 PM UTC

Look at the attached sheet.

Guess it should do the job.

View in thread

11 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
Sep 27, 2014 7:22 PM UTC

Lookup WRITEEXCEL in the hep.

Translate
    MikeArmstrong1-Visitor
    1-Visitor
    Sep 28, 2014 3:23 PM UTC

    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.

    Translate
      Werner_E
      Werner_E25-Diamond I
      25-Diamond I
      Sep 28, 2014 5:22 PM UTC

      WRITEEXCEL supports OpenXML (*.xlsx) files.

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

      Translate
      payman1-VisitorAuthor
      1-Visitor
      Sep 28, 2014 10:14 PM UTC

      Thank you.

      But it overwrites the previously calculated values.

      Translate
      Werner_E
      Werner_E25-Diamond I
      25-Diamond I
      Sep 28, 2014 10:43 PM UTC

      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.

      Translate
      Rais1-Visitor
      1-Visitor
      Nov 6, 2014 6:02 AM UTC

      Link to Excel Inputs


      Video Link : 5443

      Output to Excel

      Video Link : 5445

      MathCad/Input file/ppt


      Translate
        Terms & ConditionsAccessibility statement