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

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Parse Excel File and record data

ptc-6292144
3-Visitor

Parse Excel File and record data

Hello,

Does anyone know of a way to be able to choose an excel document on my computer and have the Thingworx server upload it and then parse through the data and add it to a Data Table?

Thank you,

Mike

2 REPLIES 2

You can upload a file to a repository using the file upload widget. I haven't been able to parse an xls file, but you can install the CSVParser extension (section "05.01.03.04 CSVParserFunctions" of the wiki) and use the services there to parse the file.



Thank you for the help David!



Top Tags