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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

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

GunwantP
6-Contributor

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

 



1 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 

GunwantP
6-Contributor
(To:VladimirN)

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.

Top Tags