export to excel

[btkaruna]

hi,

i have 3 grids displayed side by side holiding details.this i need to export to excel sheet.

If i am using RenderControl(htmlWrite) i am able to export to excel sheet but the three grids are being displayed one below other, but i require it to be showed side by side




By using div tag and using innerHtml i am able to print these details in new window.By using this info can i export the data to Excel sheet.


my question is using innerhtml can i export data with in div tag to excel sheet.if so pl. help me out in giving sample.


Thanks in advance
karuna

[Igor Soukhov]

The simplest solution in your case is to create a CSV (comma separated values) file and feed this file to MS Excel.

So the problem comes down to creation of the CSV file. Iterate thru columns and rows of the grid and put cell values (separating them by commas) into CSV files - one line in the CSV file for each row in the grid.

After CSV file is created open it using MS Excel.

hi,

i have 3 grids displayed side by side holiding details.this i need to export to excel sheet.

If i am using RenderControl(htmlWrite) i am able to export to excel sheet but the three grids are being displayed one below other, but i require it to be showed side by side




By using div tag and using innerHtml i am able to print these details in new window.By using this info can i export the data to Excel sheet.


my question is using innerhtml can i export data with in div tag to excel sheet.if so pl. help me out in giving sample.


Thanks in advance
karuna