C# Class GraphCommonsExcelBusiness.ExcelUtility

Afficher le fichier Open project: Batierk/Graph-Commons-Excel-Lab

Méthodes publiques

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

Private Methods

Méthode	Description
PrepareDataTableForExcel ( SpreadsheetLight.SLDocument doc ) : DataTable

Method Details

GetExcelMetaData() public static méthode

public static GetExcelMetaData ( Stream ms ) : ExcelMetaData
ms	Stream
Résultat	GraphCommonsExcelBusiness.Models.ExcelMetaData

GetIndexedColumnNames() public static méthode

public static GetIndexedColumnNames ( SpreadsheetLight.SLDocument doc ) : string>.Dictionary
doc	SpreadsheetLight.SLDocument
Résultat	string>.Dictionary

LoadExcelIntoDataTable() public static méthode

public static LoadExcelIntoDataTable ( string filePath ) : DataTable
filePath	string
Résultat	System.Data.DataTable