How to load a excel from database..?

Question

hi all, i need to create a excel and load it from database(datatable,dataset). how to do it

Glen Lewis · Answer

Hi, try this: // Create new file. ExcelFile file = new ExcelFile (); // Iterate through all DataTables. foreach ( DataTable dataTable in dataSet.Tables) { // Create new sheet. var sheet = file.Worksheets.Add(dataTable.TableName); // Insert DB data. sheet.InsertDataTable(dataTable, new InsertDataTableOptions ( "A1" ) { ColumnHeaders = true }); } // Save file. file.Save( "DataSet.xlsx" ); You can also check out this sample of both importing and exporting DataSet object to an Excel file . Code uses this .NET DLL for Excel handling .

Rahul Prasad · Answer

refer http://www.e-iceblue.com/Knowledgebase/Spire.DataExport/Program-Guide/How-to-Export-Datatable-to-Excel-through-DataGridView.html , it demonstrates how to programmatically create an excel file from datatable with a sample. kind regards

Vasu Gadhiya · Answer

Check this One http://www.c-sharpcorner.com/UploadFile/ae35ca/read-and-write-excel-data-using-C-Sharp/

Abhay Shanker · Answer

Check the link http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/

prathaban durai · Answer

yes..need to fetch columns from datatable and load into excel.

Vasu Gadhiya · Answer

You mean First Create Excel File and than after Write data from Database(datatable, dataset) in to excel file ?

How to load a excel from database..?

Answers (6)