C# Класс Microsoft.Legal.MatterCenter.Common.ExcelOperations

A class provides Excel related operations to read Excel sheets

Показать файл Открыть проект

Открытые методы

Метод	Описание
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

Приватные методы

Метод	Описание
ReadRow ( Row row, DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart ) : Collection	Function is used to read row values for the provided excel sheet

Описание методов

IsNullOrEmptyCredential() публичный статический Метод

Function to validate user credentials

public static IsNullOrEmptyCredential ( string userName, string password ) : bool
userName	string	User name to validate
password	string	Password to validate
Результат	bool

ReadFromExcel() публичный статический Метод

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
Результат	string>.Dictionary

ReadSheet() публичный статический Метод

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
Результат	Collection>