C# Class Owl.Excel.DataTableImporter

Mostrar archivo Open project: FerHenrique/Owl Class Usage Examples

Public Methods

Method Description
DataTableImporter ( ) : System
ImportDataSet ( SpreadsheetDocument package, DataSet dataset ) : void
ImportDataTable ( SpreadsheetDocument package, DataTable table, string sheetName ) : void

Private Methods

Method Description
CreateContentRow ( DataRow dataRow, int rowIndex ) : Row
CreateNumberCell ( int columnIndex, int rowIndex, object cellValue, Type dataType ) : Cell
CreateTextCell ( int columnIndex, int rowIndex, object cellValue ) : Cell
GetColumnName ( int columnIndex ) : string

Gets the Excel column name based on a supplied index number.

Method Details

DataTableImporter() public method

public DataTableImporter ( ) : System
return System

ImportDataSet() public method

public ImportDataSet ( SpreadsheetDocument package, DataSet dataset ) : void
package SpreadsheetDocument
dataset System.Data.DataSet
return void

ImportDataTable() public method

public ImportDataTable ( SpreadsheetDocument package, DataTable table, string sheetName ) : void
package SpreadsheetDocument
table System.Data.DataTable
sheetName string
return void