creting an excel file from dataset or access file

Question

User-1902495455 posted

hello

i have an asp.net application

c# code

i have adtabase in access and i craete adatset from it

i want to create excell file

 

adnan 

Answer 1

User-1659704165 posted

Hi,

http://tim.mackey.ie/HowtoExportADatasetToExcelCAspnet.aspx

http://snippets.dzone.com/posts/show/7762

Answer 2

User-228050481 posted

I just want to add that the method provided by the above poster simply creates an .xls file containing the html table tags which can be read & parsed correctly into Excel (ie. edit the file using notepad and you'll see). The only downside is that when opening such file, excel will prompt a warning message saying it's not "real" excel format or something to that effect. Other than that, edit & resave the file will generate true excel format. To export a file into "real" excel format, you'll need to install MS Excel component on the IIS server and use that component to generate the excel file.