C# Class Microsoft.Research.DataOnboarding.FileService.FileProcesser.Extensions.SpreadsheetDocumentExtension

Extension methods for a Excel SpreadSheet.

Afficher le fichier Open project: CDLUC3/dataup2

Méthodes publiques

Méthode	Description
GetSheet ( this document, string sheetName ) : Sheet
InsertMetadataWorksheet ( this document, bool hasFileLevelMetadata, bool hasColumnLevelMetaData ) : Sheet
IsHidden ( this sheet ) : bool
SetCellValue ( this document, Sheet metadataSheet, string addressName, string value ) : bool

Private Methods

Méthode	Description
GenerateParameterTablePartContent ( DocumentFormat.OpenXml.Packaging.TableDefinitionPart tableDefinitionPart, bool hasFileLevelMetadata ) : void	Generates content of tableDefinitionPart1.
GeneratePartContent ( DocumentFormat.OpenXml.Packaging.WorksheetPart part, string partIds ) : void	Generates the content of the WorkSheet part.
GenerateTableDefinitionPartContent ( DocumentFormat.OpenXml.Packaging.TableDefinitionPart tableDefinitionPart ) : void	Generates content of tableDefinitionPart1.

Method Details

GetSheet() public static méthode

public static GetSheet ( this document, string sheetName ) : Sheet
document	this
sheetName	string
Résultat	Sheet

InsertMetadataWorksheet() public static méthode

public static InsertMetadataWorksheet ( this document, bool hasFileLevelMetadata, bool hasColumnLevelMetaData ) : Sheet
document	this
hasFileLevelMetadata	bool
hasColumnLevelMetaData	bool
Résultat	Sheet

IsHidden() public static méthode

public static IsHidden ( this sheet ) : bool
sheet	this
Résultat	bool

SetCellValue() public static méthode

public static SetCellValue ( this document, Sheet metadataSheet, string addressName, string value ) : bool
document	this
metadataSheet	Sheet
addressName	string
value	string
Résultat	bool