Member Avatar for techinvest

How to export excel in c#.net on button click

  • 3 Contributors
  • 3 Replies
  • 222 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by techinvest
Member Avatar for JorgeM

You will need to elaborate. What do you mean export excel? Do you have a table of info you want saved to excel?

Member Avatar for EterS

Need to export data from database to Excel? or Excel to Database?

If the former, I think this article http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/ may give you some suggestions.

If the later, I want to introduce my solution with a commercial Excel library to export data from Excel sheet to datatable.

            //Load workbook
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(Server.MapPath("./test.xls"), ExcelVersion.Version97to2003);
            //Export data to datatable
            DataTable dt = workbook.Worksheets[0].ExportDataTable();
Member Avatar for techinvest

Please Reply fast it's urgent..
How to export data from database to Excel in c#.net

Edited by techinvest
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.