C# Class Microsoft.Legal.MatterCenter.Common.ExcelOperations

A class provides Excel related operations to read Excel sheets

Afficher le fichier Open project: Microsoft/mattercenter

Méthodes publiques

Méthode	Description
IsNullOrEmptyCredential ( string userName, string password ) : bool	Function to validate user credentials
ReadFromExcel ( string filePath, string sheetName ) : string>.Dictionary	This function reads Excel file and returns dictionary
ReadSheet ( string filePath, string sheetName ) : Collection>	Function is used to return all the values that are read from Sheet

Private Methods

Méthode	Description
ReadRow ( Row row, DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart ) : Collection	Function is used to read row values for the provided excel sheet

Method Details

IsNullOrEmptyCredential() public static méthode

Function to validate user credentials

public static IsNullOrEmptyCredential ( string userName, string password ) : bool
userName	string	User name to validate
password	string	Password to validate
Résultat	bool

ReadFromExcel() public static méthode

This function reads Excel file and returns dictionary

public static ReadFromExcel ( string filePath, string sheetName ) : string>.Dictionary
filePath	string	Full path to Excel file
sheetName	string	Sheet name containing configurations
Résultat	string>.Dictionary

ReadSheet() public static méthode

Function is used to return all the values that are read from Sheet

public static ReadSheet ( string filePath, string sheetName ) : Collection>
filePath	string	File path of the Excel
sheetName	string	Sheet to be read from Excel
Résultat	Collection>