C# Class GraphCommonsExcelBusiness.ExcelUtility

Mostrar archivo Open project: Batierk/Graph-Commons-Excel-Lab

Public Methods

Method	Description
GetExcelMetaData ( Stream ms ) : ExcelMetaData
GetIndexedColumnNames ( SpreadsheetLight.SLDocument doc ) : string>.Dictionary
LoadExcelIntoDataTable ( string filePath ) : DataTable

Private Methods

Method	Description
PrepareDataTableForExcel ( SpreadsheetLight.SLDocument doc ) : DataTable

Method Details

GetExcelMetaData() public static method

public static GetExcelMetaData ( Stream ms ) : ExcelMetaData
ms	Stream
return	GraphCommonsExcelBusiness.Models.ExcelMetaData

GetIndexedColumnNames() public static method

public static GetIndexedColumnNames ( SpreadsheetLight.SLDocument doc ) : string>.Dictionary
doc	SpreadsheetLight.SLDocument
return	string>.Dictionary

LoadExcelIntoDataTable() public static method

public static LoadExcelIntoDataTable ( string filePath ) : DataTable
filePath	string
return	System.Data.DataTable