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

[techinvest]

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

[JorgeM]

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

[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();

[techinvest]

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