cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Importing Data in to Excel

SOLVED
Newbie

Importing Data in to Excel

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Importing Data in to Excel

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

Mike

View solution in original post

14 REPLIES 14

Re: Importing Data in to Excel

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

Mike

Re: Importing Data in to Excel

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?

Re: Importing Data in to Excel

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.

Re: Importing Data in to Excel

What version of Mathcad and Office are you running?

Mike

Re: Importing Data in to Excel

I am using Mathcad 15.0.

Re: Importing Data in to Excel

And Microsoft Office 2007.

Re: Importing Data in to Excel

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

Re: Importing Data in to Excel

Try the attached file. Description included.

Mike

Re: Importing Data in to Excel

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