Start Building Professional
Web Apps Today

export data to excel

Hi,

In the link below you have mentioned that "you can fill Excel.Application from csv string". Can you please provide me an example of how to do that

http://dhtmlx.com/docs/products/kb/index.shtml?cat=search&page=2&q=650&ssr=yes&s=serializeToCSV

Thanks
Debamita

In case of IE centric solution - it possible to create an Excell object and use its load functionality instead of setting data cell by cell. 
If you are need cross-browser solution the only working scenario is 
- export data to csv
- send csv data to server
- return the same data from server with
      Content-type:application/vnd.ms-excel
it will be opened by MS Excel 

Hi,

It would be really helpful if you could provide me a sample code code for the solution below

In case of IE centric solution - it possible to create an Excell object and use its load functionality instead of setting data cell by cell

Unfortunately there is no ready to use sample ( approach with direct Excel object creation will work only in IE on Windows-based PC, and may fail based on existing security settings )