Skip to main content
10-Marble
August 8, 2024
Solved

How to export data in to excel from grid

  • August 8, 2024
  • 2 replies
  • 2476 views

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

Best answer by PEHOWE

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

2 replies

19-Tanzanite
August 8, 2024

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

10-Marble
August 8, 2024

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
19-Tanzanite
August 8, 2024

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

Rocko
19-Tanzanite
August 8, 2024