locked
creting an excel file from dataset or access file RRS feed

  • 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 

    Sunday, November 21, 2010 2:15 AM

Answers

  • User-1659704165 posted

    Hi,

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

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


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, November 21, 2010 4:01 AM

All replies

  • User-1659704165 posted

    Hi,

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

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


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, November 21, 2010 4:01 AM
  • 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.

    Monday, November 29, 2010 7:02 PM