Skip to main content
sbt15-Moonstone
15-Moonstone
October 4, 2021
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
22-Sapphire I
October 4, 2021

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

View in thread

7 replies

PaiChung22-Sapphire I
22-Sapphire I
October 4, 2021

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.

Translate
sbt15-MoonstoneAuthor
15-Moonstone
October 4, 2021

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!!

Translate
PaiChung22-Sapphire IAnswer
22-Sapphire I
October 4, 2021

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

Translate
    geva15-Moonstone
    15-Moonstone
    December 20, 2021

    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

    Translate
    Terms & ConditionsAccessibility statement