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

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. 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