Importing Data in to Excel

[ross52]

I am currently running a Mathcad program in controlled loops and exporting the resulting data in to an Excel file. My problem is this; each time Mathcad goes through the loop, it overwrites the data from the previous loop. This is a an issue considering I need the data from all 24 loops. I would like to know if there is a way to capture the output from each loop of calculations and save the data in Excel in: 1. Different File Names, 2. Different Sheets of that File, 3. Different Ranges of that File. Either one of the three mentioned ways is acceptable.

Thank You

[MikeArmstrong]

Yes, this can be done. Can you upload the worksheet containing the loop?

Mike

[ross52]

I am actually not allowed to upload the file. Is it necessary to have the file, or is there a generic way to do this?

[MikeArmstrong]

Well I'm not sure how your trying to do it or how you have set your loop up.

You could post an example.

Nevertheless I will post the Excel component.

[ross52]

I couldn't get you an example program, but here is a document with a flow chart of what the program essentially looks like.

[MikeArmstrong]

Looking at the Word document, can't you just pass the whole Matrix to Excel in one go?

Why don't you post the loop with none sensitive data included?

Mike

[MikeArmstrong]

What version of Mathcad and Office are you running?

Mike

[ross52]

I am using Mathcad 15.0.

[ross52]

And Microsoft Office 2007.

[MikeArmstrong]

Try the attached file. Description included.

Mike

[MikeArmstrong · Accepted solution]

Another example for you. Not as clever, but does do the job.

Mike

[VladimirN]

In this case need to see worksheet. Can you upload them?

[MikeArmstrong]

In this case need to see worksheet. Can you upload them?

Amber has already stated that a worksheet cannot be uploaded because of confidentiality, but I do agree that this is a case where a dummy worksheet should have been created and posted.

The way the thread has run thus far will be of no benefit to new forum members.

Mike

[ross52]

I apologize for not being able to upload the original or a dummy worksheet. But my question was indeed answered by your suggestions and the program is up and running. Thank you for all your help!

[MikeArmstrong]

I apologize for not being able to upload the original or a dummy worksheet. But my question was indeed answered by your suggestions and the program is up and running. Thank you for all your help!

No problem at all, I'm glad you've found your solution.

Mike