ExportDataToExcel_SSG.ExportDataTableToExcel 1.0.1

ExportDataToExcel_SSG.ExportDataTableToExcel

1. ExportDataTableToExcel

ExportDataTableToExcel(DataTable dt, string path)

Param1: Datatable value Param2: Path of the file where you want to save the excel eg.C:/Filename.xls

2. MergingMultiDataTableAs_singleExcelSheet

MergingMultiDataTableAs_singleExcelSheet(DataTable[] dt, string path, bool n_Columns)

DataTable[] Dt=new DataTable[3]; Dt[0]=new DataTable(); Dt[0]=new DataTable(); Dt[0]=new DataTable(); Param1: Collection Of Datatable Param2: Path of the file where you want to save Param3: true or false If false First datatable columns for values If True Merging All datatable values as single sheet with each columns
Result Like: If True: One two Three 1 2 3 4 5 6 7 8 9 Four Five Six 1 2 3 4 5 6 7 8 9 ---- DataTable1

---- DataTable 2

If False One two Three 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 ----DataTable1 Columns

----- DataTable2 Values Started From

3. MultiDataTableAs_MultiExcelFile

MultiDataTableAs_MultiExcelFile(DataTable[] dt, string path)

Param1: Array of dataTable Param2: Where you want to save the excel file

In this Each datatable saving as separate Excel file Like Total DataTable is 3; So saving Dt0 as Filename.xls Dt1 as Filename_0.xls Dt2 as Filename_1.xls With whatever the column headers.

4. MergingMultiDataSetAs_singleExcelSheet

Same as 2nd Point. Instead of datatable it is dataset Dataset ds=new DataSet(); Ds.tables.add(dt1); Ds.tables.add(dt2); Ds.tables.add(dt3);

MergingMultiDataSetAs_singleExcelSheet(DataSet ds, string path, bool n_Columns)

Param1: Dataset Collection of tables Param2: Path of the file where do you want to save the excel Param3: true or false

Conclusion:

ExportDataToExcel_SSG is a library for export datatable to excel very easily without any dependency. Easily export multiple datatable as multi excel file. Dataset as excel sheet. Merging many datatables as single sheet. Merging dataset as single sheet. Easy Exception Identification

Nugget Link: https://www.nuget.org/packages/ExportDataToExcel_SSG.ExportDataTableToExcel/ Supported Frame work: 4.5 Architecture : 32 and 64 system Package Manager Console: Install-Package ExportDataToExcel_SSG.ExportDataTableToExcel -Version 1.0.0 Dependency : NULL

In Future Update:

It will export multi datatable as single excel file with multiple sheets.