Skip to main content
ptc-62921441-Visitor
1-Visitor
September 3, 2014
Question

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

      davidcor1-Visitor
      1-Visitor
      September 4, 2014

      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.



      Translate
      ptc-62921441-VisitorAuthor
      1-Visitor
      September 6, 2014

      Thank you for the help David!



      Translate
      Terms & ConditionsAccessibility statement