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



dhtmlx.com/docs/products/kb/inde … alizeToCSV



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 )