Skip to main content
R
ross521-Visitor
1-Visitor
June 28, 2011
Solved

Importing Data in to Excel

  • June 28, 2011
  • 2 replies
  • 6846 views

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

Best answer by MikeArmstrong

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

Mike

2 replies

M
MikeArmstrong1-Visitor
1-Visitor
June 28, 2011

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

Mike

R
ross521-VisitorAuthor
1-Visitor
June 28, 2011

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?

M
MikeArmstrong1-Visitor
1-Visitor
June 28, 2011

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.

V
VladimirN24-Ruby III
24-Ruby III
June 29, 2011

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

M
MikeArmstrong1-Visitor
1-Visitor
June 29, 2011

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

R
ross521-VisitorAuthor
1-Visitor
June 29, 2011

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!

Terms & ConditionsAccessibility statement