Skip to main content
Oct 4, 2021 12:37 PM UTC
Solved

Reading excel tabs in thingworx

 Hello ,

We can read the csv file from the thingworx csv extension. Is there a possibility to read the excel having multiple tabs by specifying the sheet name or something..?  .

What is the best way to read excel with multiple tabs.

 

Thanks!!

PaiChungAnswer
Oct 4, 2021 8:12 PM UTC

DPM is the new Digital Performance Management solution PTC has released.

ThingWorx Applications is actually a set of apps RTPPM (Real Time Production Performance Management), AMU (Asset Monitoring and Utilization) and CWC (Connected Work Cell) also a solution PTC has released

It isn't in the manufacturing apps which you are referring to

7 replies

Oct 4, 2021 4:29 PM UTC

It can be done with the proper java extension but I don't think one is officially available?

I think if you install something like ThingWorx Apps or DPM they have an extension included to read Excel files.

I think Manufacturing apps only does CSV not excel.

sbtAuthor
Oct 4, 2021 4:38 PM UTC

When you say thingworx app, is that "ThingWorx-Utilities-Core"/"ThingWorx-Utilities-Software-Content-Management" which is part of thingworx foundation..?

DPM stands for..??

Thanks for the response!!

PaiChungAnswer
Oct 4, 2021 8:12 PM UTC

DPM is the new Digital Performance Management solution PTC has released.

ThingWorx Applications is actually a set of apps RTPPM (Real Time Production Performance Management), AMU (Asset Monitoring and Utilization) and CWC (Connected Work Cell) also a solution PTC has released

It isn't in the manufacturing apps which you are referring to

Dec 20, 2021 11:28 AM UTC

Hello @sbt - Although it requires Excel Online (ie: Office 365 online version), ThingWorx Flow has a connector which allows triggering workflows off of and integrating through Excel files.  

https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Integration_Orchestration/ExcelOnline/ExcelOnlineConnector.html