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

Import .CSV / .XLS which is specified by string

SOLVED

Import .CSV / .XLS which is specified by string

Hello Guys

is ist possible to specify the path of an file( which i want to import with the components shown in the attached jpg) by a string.

It would be nice to have the path somewhere in the mathcad-file saved, and the components use that string..

So that I dont have to use the ***** menu of the components!?

I hope you understand by poor english

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Import .CSV / .XLS which is specified by string

I think I have found the problem. I don't think the function likes the .csv at the end of the page name. Try removing it and re-running the component.

Remember once the component has turned red you will have to right click, edit script, and click apply (tick sign)

Mike

View solution in original post

15 REPLIES 15

Re: Import .CSV / .XLS which is specified by string

is ist possible to specify the path of an file( which i want to import with the components shown in the attached jpg) by a string.

It would be nice to have the path somewhere in the mathcad-file saved, and the components use that string..

Have a look at the attached worksheet, which uses a scripted component where range and sheet number can be specified within Mathcad.

Mike

Re: Import .CSV / .XLS which is specified by string

Looks fine, but i get an error-message.

Re: Import .CSV / .XLS which is specified by string

Make sure the path is correct. Can you upload both worksheets.

Mike

Re: Import .CSV / .XLS which is specified by string

The Path is correct, but i cant upload the sheets.

Do I need Mathcad 15?

Re: Import .CSV / .XLS which is specified by string

What version of Mathcad and Office do you have.

Have a look at the image below, the component works.

Try right clicking on the component, edit script and click the tick (Apply)

Clipboard01.jpg

Mike

Re: Import .CSV / .XLS which is specified by string

I use Mathcad 14 and office 2003

Re: Import .CSV / .XLS which is specified by string

The component works with M14 and Excel 2003. It the file path, sheet name or cell range must be incorrect.

Can you take a screen shot of the Mathcad sheet where the file path and range is defined.

Mike

Re: Import .CSV / .XLS which is specified by string

Here you are.

Re: Import .CSV / .XLS which is specified by string

Have you saved both of the files to your hardrive? I have had that problem before.

Make sure the Excel sheet is not open when you run the component.

Mike

Announcements