How to export data in to excel from grid

[LY_10838955]

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

[Velkumar]

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

[LY_10838955]

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

[Rocko]

What is unclear about that? The second link describes in detail how to use the Data Export function to create CSV.

[Jimwang]

To export CSV, you can refer to https://www.ptc.com/en/support/article/CS388962

[vnamboodheri]

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.

[PEHOWE · Accepted 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

[Rocko]

You can use this extension: https://github.com/ptc-iot-sharing/DataExportExtensionTWX