• 홈
• Microsoft
• Research
• DataOnboarding
• FileService
• FileProcesser
• ExcelFileProcesser

C# 클래스 Microsoft.Research.DataOnboarding.FileService.FileProcesser.ExcelFileProcesser

파일 보기 프로젝트 열기: CDLUC3/dataup2

공개 메소드들

메소드	설명
ExcelFileProcesser ( IBlobDataRepository blobDataRepository, IFileRepository fileDataRepository, IRepositoryService repositoryService ) : DocumentFormat.OpenXml.Packaging	Initializes a new instance of the ExcelFileProcesser class.
GetColumnMetadataFromFile ( DomainModel fileDetail ) : Task>
GetErrors ( Microsoft.Research.DataOnboarding.DomainModel file ) : Task>	Method to get the errors available on the input excel file.
RemoveError ( Stream stream, string sheetName, IEnumerable errorTypes ) : System.Threading.Tasks.Task	Removes an error from a file sheet.

비공개 메소드들

메소드	설명
CheckForRange ( string valueToCheck, string rangeValues, string headerName ) : string	Helper method to check the value of a column for the specified range.
DownloadDocument ( Microsoft.Research.DataOnboarding.DomainModel fileDetails ) : DataDetail
GetColumnIndex ( string value ) : int	Method to get column index
GetColumnIssues ( Microsoft.Research.DataOnboarding.DomainModel qualityCheck, IEnumerable qualityCheckTypes, IEnumerable headers, IEnumerable columns, QualityCheckResult qualityCheckResult ) : void
GetColumnLocationIndex ( string headerName, IEnumerable headersList ) : int	Method to Get Column Location Index
GetDocumentSheetDetails ( Microsoft.Research.DataOnboarding.DomainModel fileDetail ) : Task>
GetFileStream ( string fileID ) : Stream
GetHeaderIssues ( Microsoft.Research.DataOnboarding.DomainModel qualityCheck, IEnumerable headers, QualityCheckResult qualityCheckResult ) : void
GetQualityCheckIssues ( Microsoft.Research.DataOnboarding.DomainModel fileDetail, Microsoft.Research.DataOnboarding.DomainModel qualityCheck, IEnumerable qualityCheckTypes, string sheetIds ) : Task>
GetQualityCheckRulesForExcel ( Stream stream, string sheetIds, Microsoft.Research.DataOnboarding.DomainModel qualityCheck, IEnumerable qualityCheckTypes ) : IEnumerable	Method to get quality check validation conditions for excel object
GetSheetIds ( string sheetIds ) : List	Method to get sheet ids
IncrementColRef ( string lastRef ) : string	Returns the next Column Name as it exists in Excel Sheet
UpdateMetaDataSheetForExcel ( Microsoft.Research.DataOnboarding.DomainModel fileDetails ) : DataDetail

메소드 상세