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

Community Tip - Stay updated on what is happening on the PTC Community by subscribing to PTC Community Announcements. X

Parse Excel File and record data

ptc-6292144
3-Newcomer

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!



Announcements


Top Tags