Skip to main content
S
sbt15-Moonstone
15-Moonstone
October 4, 2021
Solved

Reading excel tabs in thingworx

  • October 4, 2021
  • 2 replies
  • 3063 views

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

Best answer by PaiChung

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

2 replies

P
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.

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

P
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

    G
    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

    Terms & ConditionsAccessibility statement