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.