cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

How to Export a Custom Excel file from Thingworx to add Pie-Charts, Bar-Charts, Line-Chart & Table ?

GunwantP
10-Marble

How to Export a Custom Excel file from Thingworx to add Pie-Charts, Bar-Charts, Line-Chart & Table ?

We have developed an Custom Extension for Thingworx for adding Tables in Excel sheet, in eclipse (Java).


How to add Charts (Pie-chart, Bar-chart, Line-chart, etc.) in the same excel file? 

 

Is it possible to export charts from Mashup to excel?
or
Is there any library(xssf) available in eclipse (Java) to generate pie chart directly by providing input data?


Please share the sample examples if available for the same.

please refer the following screenshots, I want this kind of result :

GP_9484649_0-1639540235702.png

GP_9484649_1-1639540383151.png

 



ACCEPTED SOLUTION

Accepted Solutions

Use "Excel Report Template" which will have predefined graphs. You just populate data to template file after saving as a new file.

Graphs will be populated automatically.

View solution in original post

3 REPLIES 3

There was a similar question earlier - "How to take data from csv and plot it": https://community.ptc.com/t5/ThingWorx-Developers/How-to-take-data-from-csv-and-plot-it/td-p/553664 

Thank you @VladimirN for your response, but the solution you suggested is to import data from  CSV --> to Thingworx, where as my concern is to export Mashup data, Charts (pie-chart, bar-chart, line-chart) to Excel file.
Please suggest a solution or any custom extension to export data from  Thingworx Mashup --> to Excel file


Use "Excel Report Template" which will have predefined graphs. You just populate data to template file after saving as a new file.

Graphs will be populated automatically.

Announcements


Top Tags