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

Extension methods for a Excel SpreadSheet.

显示文件 Open project: CDLUC3/dataup2

Public Methods

Method	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

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

public static GetSheet ( this document, string sheetName ) : Sheet
document	this
sheetName	string
return	Sheet

InsertMetadataWorksheet() public static method

public static InsertMetadataWorksheet ( this document, bool hasFileLevelMetadata, bool hasColumnLevelMetaData ) : Sheet
document	this
hasFileLevelMetadata	bool
hasColumnLevelMetaData	bool
return	Sheet

IsHidden() public static method

public static IsHidden ( this sheet ) : bool
sheet	this
return	bool

SetCellValue() public static method

public static SetCellValue ( this document, Sheet metadataSheet, string addressName, string value ) : bool
document	this
metadataSheet	Sheet
addressName	string
value	string
return	bool