C# Class Microsoft.Research.DataOnboarding.FileService.FileProcesser.ExcelFileProcesser

Inheritance: FileProcessor, IFileProcesser

Datei anzeigen Open project: CDLUC3/dataup2

Public Methods

Method	Description
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.

Private Methods

Method	Description
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

Method Details

ExcelFileProcesser() public method

Initializes a new instance of the ExcelFileProcesser class.

public ExcelFileProcesser ( IBlobDataRepository blobDataRepository, IFileRepository fileDataRepository, IRepositoryService repositoryService ) : DocumentFormat.OpenXml.Packaging
blobDataRepository	IBlobDataRepository	Blob repository object.
fileDataRepository	IFileRepository
repositoryService	IRepositoryService
return	DocumentFormat.OpenXml.Packaging

GetColumnMetadataFromFile() public method

public GetColumnMetadataFromFile ( DomainModel fileDetail ) : Task>
fileDetail	DomainModel
return	Task>

GetErrors() public method

Method to get the errors available on the input excel file.

public GetErrors ( Microsoft.Research.DataOnboarding.DomainModel file ) : Task>
file	Microsoft.Research.DataOnboarding.DomainModel	File
return	Task>

RemoveError() public method

Removes an error from a file sheet.

public RemoveError ( Stream stream, string sheetName, IEnumerable errorTypes ) : System.Threading.Tasks.Task
stream	Stream	Stream
sheetName	string	Sheet Name
errorTypes	IEnumerable	Error types
return	System.Threading.Tasks.Task