Skip to main content
ArneClaußen1-Visitor
1-Visitor
March 11, 2011
Solved

Import .CSV / .XLS which is specified by string

  • March 11, 2011
  • 15 replies
  • 9653 views

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

Best answer by MikeArmstrong

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

15 replies

MikeArmstrong1-Visitor
1-Visitor
March 11, 2011
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

ArneClaußen1-VisitorAuthor
1-Visitor
March 11, 2011

Looks fine, but i get an error-message.

MikeArmstrong1-Visitor
1-Visitor
March 11, 2011

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

Mike

Terms & ConditionsAccessibility statement