C# 클래스 Microsoft.Legal.MatterCenter.Common.ExcelOperations

A class provides Excel related operations to read Excel sheets

파일 보기 프로젝트 열기: Microsoft/mattercenter

공개 메소드들

메소드	설명
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>