Improvement for datagrid - Download data in excel or xml format

[acreonte82]

Hello sworty,
can be an interesting feature if you can build the function to download the entire datagrid in a excel or xml file .

I know there are a lot of tool in php to do this, but in my opinion can help many developers...

What you think?

[stworthy]

It is much easier to export to CSV than exporting a file using Excel format. Using XML would work the same way but the XML format is much heavier. Call 'getRows' method to get all the rows and then convert to CSV.

Code:

var rows = $('#dg').datagrid('getRows');
// convert to CSV

[acreonte82]

Ok I know this function. But in my opinion can be more professional to have a native function that export into Excel file...

[reems]

Hi,

Supposing you have the data in your datagrid also serverside in a database or so, it's easier to use a library as phpexcel for this. I have very good results with it and also can take care of styling the excel file with this.

[JohnWang]

   yeah, I'm looking forward to see EasyUI add the function of downloading row datas into excel or CSV files...

[acreonte82]

Hi,

Supposing you have the data in your datagrid also serverside in a database or so, it's easier to use a library as phpexcel for this. I have very good results with it and also can take care of styling the excel file with this.

This is no a problem... I use phpexcel too...

My requeste is an idea to have this functionality in the framework.. Nothing more..

If the team developers don't want it, I continue to use the phpexcel class...

[aswzen]

yes, i think it should be a major feature in easyUI, because exporting HTML table using javascript is very possible now.
 

[acreonte82]

yes, i think it should be a major feature in easyUI, because exporting HTML table using javascript is very possible now.
 

In my opinion can be great if the  team developers produce 2 solutions:
1. client side;
2. server side ;