C# Class Microsoft.Research.DataOnboarding.FileService.Helper.ExcelFileHelper

Helper class for XL file related methods

Afficher le fichier Open project: CDLUC3/dataup2

Méthodes publiques

Méthode	Description
RemoveError ( SpreadsheetDocument document, string sheetName, ErrorType errorType ) : System.Threading.Tasks.Task	Removes an error from a file sheet.
ValidateGraphics ( SpreadsheetDocument document ) : Task>	Validates the graphics.

Private Methods

Méthode	Description
CellHasCommas ( Microsoft.Research.DataOnboarding.FileService.Models.SheetCell cell ) : bool
CellHasSpecialCharacters ( Microsoft.Research.DataOnboarding.FileService.Models.SheetCell cell ) : bool
CellHasStyleErrors ( Microsoft.Research.DataOnboarding.FileService.Models.SheetCell cell, CellFormat>.Dictionary sharedFormatList ) : bool
CheckSheetForData ( SpreadsheetDocument document, string sheetId ) : bool
CreateCellFormatsList ( CellFormats formats ) : CellFormat>.Dictionary
CreateColumnLevelMetadataList ( string sheetName, IEnumerable headerCells ) : IList
CreateSharedStringList ( SharedStringTable table ) : string>.Dictionary
ExcelFileHelper ( ) : DocumentFormat.OpenXml.Drawing.Charts	Static constructor.
GetCelltype ( string type, Cell cellsInColumn, CellFormat>.Dictionary sharedFormatList ) : string	Gets the celltype.
GetColumnLocationIndex ( string location ) : int	Method to get column location index
GetColumnMetadataForAllSheets ( SpreadsheetDocument document ) : IEnumerable
GetColumnName ( string cellName ) : string	Gets the name of the column.
GetColumnNameFromIndex ( string columnIndex ) : string	Gets the Excel Column Name from the Column Index.
GetColumnNames ( string lastColumn = "XFD" ) : List	Gets the column names.
GetHeaders ( SpreadsheetDocument document, string sheetId ) : IEnumerable
GetHeadersAndColumns ( SpreadsheetDocument document, string sheetId ) : IEnumerable
GetRowIndex ( string cellName ) : int	Gets the index of the row.
GetWorkSheetBounds ( DocumentFormat.OpenXml.Packaging.WorksheetPart part ) : string[]	Gets the work sheet bounds.
RemoveCharts ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart ) : void	Removes charts in a excel sheet.
RemoveColorCells ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart, DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart ) : void	Removes color cells in a excel sheet.
RemoveComments ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart ) : void	Removes comments in a excel sheet.
RemoveMergeCells ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart ) : void	Removes merge cells in a excel sheet.
RemovePictures ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart ) : void	Removes pictures in a excel sheet
RemoveShapes ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart ) : void	Removes shapes in a excel sheet.
RetrieveCellErrors ( DocumentFormat.OpenXml.Packaging.WorksheetPart part, CellStyles cellstyle, string sheetName, string sheetId, string>.Dictionary sharedStringList, CellFormat>.Dictionary sharedFormatList ) : IList	Retrieves the cell errors.
RetrieveChartErrors ( DocumentFormat.OpenXml.Packaging.DrawingsPart part, string sheetName, string sheetId ) : IList	Retrieves the chart errors.
RetrieveCommentErrors ( DocumentFormat.OpenXml.Packaging.WorksheetPart part, string sheetName, string sheetId ) : IList	Retrieves the comment errors.
RetrieveMergedCellErrors ( DocumentFormat.OpenXml.Packaging.WorksheetPart part, string sheetName, string sheetId ) : IList	Retrieves the merged cell errors.
RetrieveMixedDataTypeErrors ( DocumentFormat.OpenXml.Packaging.WorksheetPart part, IEnumerable cells, string sheetName, string sheetId, CellFormat>.Dictionary sharedFormatList ) : IList	Retrieves the mixed data type errors.
RetrievePicErrors ( DocumentFormat.OpenXml.Packaging.DrawingsPart part, string sheetName, string sheetId ) : IList	Retrieves the pic errors.
RetrieveShapeErrors ( DocumentFormat.OpenXml.Packaging.DrawingsPart part, string sheetName, string sheetId ) : IList	Retrieves the shape errors.

Method Details

RemoveError() public static méthode

Removes an error from a file sheet.

public static RemoveError ( SpreadsheetDocument document, string sheetName, ErrorType errorType ) : System.Threading.Tasks.Task
document	SpreadsheetDocument	Spreadsheet document
sheetName	string	Sheet Name
errorType	ErrorType	Error type
Résultat	System.Threading.Tasks.Task

ValidateGraphics() public static méthode

Validates the graphics.

public static ValidateGraphics ( SpreadsheetDocument document ) : Task>
document	SpreadsheetDocument	The document.
Résultat	Task>