Export to Excel

[JonC]

I am trying to export data from a Store to an excel file. The store is not linked to a grid though (I just want to pull the data in from the DB and export it). I used the OnSubmitData to fire the code behind. It successfully creates an Excel file, but it is blank! I belive the xmlNode I am creating is blank. How can I get an XmlNode from a Store?

Thanks,
Jon

[geoffrey.mcgill]

Hi,

The following sample demonstrates exporting data in several different formats.

https://examples1.ext.net/#/GridPane...ort_Data_Ajax/

Hope this helps.

[JonC]

That is the example I have been working off of. However, it only shows how to get the XmlNode object from a gridpanel record, and I need to be able to extract one from the Store itself.

[Daniil]

Hi,

You can use the Store's getRecordsValues method instead of the GridPanel's getRowsValues one.

[JonC]

After some work, I managed to get the record to export to excel. However, it simply comes as a basic table. I tried editing the .xsl file, but I cannot find a good guide for styling the exported excel file. Could you please provide me with some information on how to customize the excel file? For instance, I would like to export the file with the fields as rows and the values as columns. Is this possible?

Thank you,
Jon

[geoffrey.mcgill]

After some work, I managed to get the record to export to excel. However, it simply comes as a basic table. I tried editing the .xsl file, but I cannot find a good guide for styling the exported excel file. Could you please provide me with some information on how to customize the excel file? For instance, I would like to export the file with the fields as rows and the values as columns. Is this possible?

Thank you,
Jon

It would probably be best to use the Google to find the correct format required by Excel.