C# Class BExIS.IO.Transform.Output.ExcelWriter

Inheritance: DataWriter

Méthodes publiques

Méthode	Description
AddDataTuplesToTemplate ( DatasetManager datasetManager, List dataTuplesIds, string filePath, long dataStructureId ) : List	Add Datatuples to a Excel Template file
AddDataTuplesToTemplate ( List dataTuples, string filePath, long dataStructureId ) : List	Add Datatuples to a Excel Template file
CreateFile ( long datasetId, long datasetVersionOrderNr, long dataStructureId, string title, string extention ) : string
IsTemplate ( Stream file ) : bool

Méthode	Description
AddRows ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart, int startRow, int endRow, List dataTuples ) : void	Add Rows to a WorksheetPart
AddRows ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart, int startRow, int endRow, List dataTuplesIds, DatasetManager datasetManager ) : void	Add Rows to a WorksheetPart
DatatupleToRow ( AbstractTuple dataTuple, int rowIndex ) : Row	Convert a Datatuple to a Row
DatatupleToRow ( long dataTupleId, int rowIndex ) : Row	Convert a Datatuple to a Row
GetEmptyCell ( int rowIndex, int columnIndex ) : Cell	Get a empty cell
VariableValueToCell ( VariableValue variableValue, int rowIndex, int columnIndex ) : Cell	Convert a VariableValue to Cell

Méthode	Description
buildDefinedNamesTable ( DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart ) : List
changeDefinedNamesTable ( DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart ) : List
generateStyle ( SpreadsheetDocument spreadsheetDocument ) : void
getColumnIndex ( int index, int offset = 1 ) : string
getColumnName ( string cellName ) : string	Given a cell name, parses the specified cell to get the column name.
getColumnNumber ( string columnName ) : int	Given a cell name, parses the specified cell to get the column number.
getExcelStyleIndex ( string systemType, uint styleIndex ) : uint
getExcelType ( string systemType ) : CellValues
getVariableIdentifiers ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart, int startRow, int endRow ) : List
getVariableIds ( string stringlist ) : List
getWorkSheetPart ( DocumentFormat.OpenXml.Packaging.WorkbookPart workbookPart, DefinedNameVal definedName ) : DocumentFormat.OpenXml.Packaging.WorksheetPart
rowToList ( Row r ) : List

Add Datatuples to a Excel Template file

public AddDataTuplesToTemplate ( DatasetManager datasetManager, List dataTuplesIds, string filePath, long dataStructureId ) : List
datasetManager	BExIS.Dlm.Services.Data.DatasetManager
dataTuplesIds	List
filePath	string	Path of the excel template file
dataStructureId	long	Id of datastructure
Résultat	List

Add Datatuples to a Excel Template file

public AddDataTuplesToTemplate ( List dataTuples, string filePath, long dataStructureId ) : List
dataTuples	List	Datatuples to add
filePath	string	Path of the excel template file
dataStructureId	long	Id of datastructure
Résultat	List

Add Rows to a WorksheetPart

protected AddRows ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart, int startRow, int endRow, List dataTuples ) : void
worksheetPart	DocumentFormat.OpenXml.Packaging.WorksheetPart
startRow	int
endRow	int
dataTuples	List
Résultat	void

Add Rows to a WorksheetPart

protected AddRows ( DocumentFormat.OpenXml.Packaging.WorksheetPart worksheetPart, int startRow, int endRow, List dataTuplesIds, DatasetManager datasetManager ) : void
worksheetPart	DocumentFormat.OpenXml.Packaging.WorksheetPart
startRow	int
endRow	int
dataTuplesIds	List
datasetManager	BExIS.Dlm.Services.Data.DatasetManager
Résultat	void

public CreateFile ( long datasetId, long datasetVersionOrderNr, long dataStructureId, string title, string extention ) : string
datasetId	long
datasetVersionOrderNr	long
dataStructureId	long
title	string
extention	string
Résultat	string

Convert a Datatuple to a Row

protected DatatupleToRow ( AbstractTuple dataTuple, int rowIndex ) : Row
dataTuple	BExIS.Dlm.Entities.Data.AbstractTuple	Datatuple to convert
rowIndex	int	Position of the Row
Résultat	Row

Convert a Datatuple to a Row

protected DatatupleToRow ( long dataTupleId, int rowIndex ) : Row
dataTupleId	long	Id of the Datatuple to convert
rowIndex	int	Position of the Row
Résultat	Row

Get a empty cell

protected GetEmptyCell ( int rowIndex, int columnIndex ) : Cell
rowIndex	int
columnIndex	int
Résultat	Cell

public IsTemplate ( Stream file ) : bool
file	Stream
Résultat	bool

Convert a VariableValue to Cell

protected VariableValueToCell ( VariableValue variableValue, int rowIndex, int columnIndex ) : Cell
variableValue	BExIS.Dlm.Entities.Data.VariableValue
rowIndex	int
columnIndex	int
Résultat	Cell