Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
Hi Everyone,
I have grid widget which data is populated through a SQL service, and I want to export that data which is in the grid into an excel file , can I do that if so then please share the solution.
Thanks and Regards,
Lavkush
Solved! Go to Solution.
Hello @LY_10838955 ,
Exporting data from ThingWorx to an Excel format is not an OOTB supported feature.
If you are willing to create your own ThingWorx Extension, the Apache POI library is a Java Library which can read and write Excel files. Using the library and the ThingWorx Extension SDK, you can create an extension which Reads/writes from /to ThingWorx directly to an Excel file. The reading of data is also possible. I have looked at this problem and may be able to provide some background if you have a developer which is interested in creating a solution.
Regards,
Pehowe
Hi @LY_10838955
Please refer this link - Article - CS257590 - Is it possible to export data to Excel and PDF files in ThingWorx Platform (ptc.com)
To export as CSV file - Data Export (ptc.com)
/VR
Hi @Velkumar ,
Even if I want to export in csv form then how can i export because it is saying in csv we can export
so please suggest
Regards,
Lavkush
What is unclear about that? The second link describes in detail how to use the Data Export function to create CSV.
To export CSV, you can refer to https://www.ptc.com/en/support/article/CS388962
Hello @LY_10838955,
It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution.
Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.
Thanks,
Vivek N.
Community Moderation Team.
Hello @LY_10838955 ,
Exporting data from ThingWorx to an Excel format is not an OOTB supported feature.
If you are willing to create your own ThingWorx Extension, the Apache POI library is a Java Library which can read and write Excel files. Using the library and the ThingWorx Extension SDK, you can create an extension which Reads/writes from /to ThingWorx directly to an Excel file. The reading of data is also possible. I have looked at this problem and may be able to provide some background if you have a developer which is interested in creating a solution.
Regards,
Pehowe
You can use this extension: https://github.com/ptc-iot-sharing/DataExportExtensionTWX