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

Forum|Forum|4 years ago
December 15, 2021
2 replies
2673 views

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 :

Best answer by Sathishkumar_C

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.

V

VladimirN

24-Ruby III

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

G

GunwantP

Author

10-Marble

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