Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
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 :
Solved! Go to Solution.
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.
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.