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

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! 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