I’m
exporting the Dot NET data grid to an excel file.
When
I open the file and save, it gets saved as excel workbook. Whereas when I
directly save, it gets saved as an excel file but actually the content is xml
or html based on how I export the grid content to excel. If I render control
using HTML Writer the data is saved in html format. If I form xml tags and
export the grid data then the actual data behind is in xml format but the content
is presented as excel to the user.
Kindly
let me know how I can export a Dot NET grid in such a way that the actual
content goes as excel file (in binary format).
Note:
When I read the uploaded excel file using oledb connection I cannot open an excel
file whose content is actually xml or html. That’s the reason why I want to
export the grid content to actual excel file.