cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Reading excel tabs in thingworx

Go to solution
sbt
15-Moonstone
15-Moonstone
‎Oct 04, 2021 08:37 AM
‎Oct 04, 2021 08:37 AM

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

0 Kudos
Notify Moderator
ACCEPTED SOLUTION

Accepted Solutions
PaiChung
22-Sapphire I
22-Sapphire I
(To:sbt)
‎Oct 04, 2021 04:12 PM
‎Oct 04, 2021 04:12 PM

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 solution in original post

Notify Moderator
7 REPLIES 7
PaiChung
22-Sapphire I
22-Sapphire I
(To:sbt)
‎Oct 04, 2021 12:29 PM
‎Oct 04, 2021 12:29 PM

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.

0 Kudos
Notify Moderator
sbt
15-Moonstone
15-Moonstone
(To:PaiChung)
‎Oct 04, 2021 12:38 PM
‎Oct 04, 2021 12:38 PM

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

0 Kudos
Notify Moderator
PaiChung
22-Sapphire I
22-Sapphire I
(To:sbt)
‎Oct 04, 2021 04:12 PM
‎Oct 04, 2021 04:12 PM

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

Notify Moderator
sbt
15-Moonstone
15-Moonstone
(To:PaiChung)
‎Oct 06, 2021 03:36 AM
‎Oct 06, 2021 03:36 AM

Sorry!! i am not sure i am looking at right place for the download. Is it possible for you to send a link or the screen capture of the installable which you are talking about.

Thanks for all your support.

0 Kudos
Notify Moderator
slangley
23-Emerald II
23-Emerald II
(To:sbt)
‎Oct 15, 2021 04:45 PM
‎Oct 15, 2021 04:45 PM

Hi @sbt.

 

You can find more information on DPM here.  It's my understanding that DPM is releasing next month, but I'm trying to verify the date.

 

Regards.

 

--Sharon

0 Kudos
Notify Moderator
slangley
23-Emerald II
23-Emerald II
(To:slangley)
‎Oct 18, 2021 09:09 AM
‎Oct 18, 2021 09:09 AM

Hi @sbt.

 

My apologies. I discovered that DPM is available.  It requires a paid subscription and is available for distribution through Solution Central.

 

Regards.

 

--Sharon

Notify Moderator
geva
15-Moonstone
15-Moonstone
(To:sbt)
‎Dec 20, 2021 06:28 AM
‎Dec 20, 2021 06:28 AM

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

0 Kudos
Notify Moderator
Announcements


Contact Community Management
Top Tags