Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by farook on May 17, 2009 23:36
open dhtmlx forum
how can i export data to different file formats like excel,csv,etc

Hi,
can u please tell me how can i export data to different file formats from grid.

Answer posted by Support on May 18, 2009 02:42
You can export data from grid by serialization

grid can be serialized to xml
 var xml = grid.serialize();
or to csv
  var csv = grid.serializeToCSV(); //dhtmlxgrid_nxml.js required

result of serialization is a string, if you need to send it as file - you need to send it server first and return with valid headers ( CSV file with valid headers will be opened in excel automatically )

Also, you can check
http://dhtmlx.com/docs/products/kb/index.shtml?cat=search&page=1&q=8082&ssr=yes&s=csv%20file