C# Class BExIS.RPM.Output.ExcelTemplateProvider

Show file Open project: BEXIS2/Core Class Usage Examples

Public Methods

Method Description
CreateTemplate ( List variables, string path, string filename ) : SpreadsheetDocument

CreateTemplate ( List variableIds, long dataStructureId, string path, string filename ) : SpreadsheetDocument

CreateTemplate ( StructuredDataStructure dataStructure ) : string
CreateTemplate ( long id ) : void

ExcelTemplateProvider ( ) : System

ExcelTemplateProvider ( string fileName ) : System

deleteTemplate ( long dataStrctureId ) : void

getOrderedVariables ( StructuredDataStructure structuredDataStructure ) : List
getOrderedVariables ( long dataStructureID, List Variables ) : List

Private Methods

Method Description
GetClomunIndex ( int index, int offset = 1 ) : string

GetRows ( Worksheet worksheet, int start, int end ) : List

getExcelStyleIndex ( DataType dataType, List styleIndex ) : uint

getExcelType ( string systemType ) : CellValues

Method Details

CreateTemplate() public method

public CreateTemplate ( List variables, string path, string filename ) : SpreadsheetDocument
variables List
path string
filename string
return SpreadsheetDocument

CreateTemplate() public method

public CreateTemplate ( List variableIds, long dataStructureId, string path, string filename ) : SpreadsheetDocument
variableIds List
dataStructureId long
path string
filename string
return SpreadsheetDocument

CreateTemplate() public method

public CreateTemplate ( StructuredDataStructure dataStructure ) : string
dataStructure StructuredDataStructure
return string

CreateTemplate() public method

public CreateTemplate ( long id ) : void
id long
return void

ExcelTemplateProvider() public method

public ExcelTemplateProvider ( ) : System
return System

ExcelTemplateProvider() public method

public ExcelTemplateProvider ( string fileName ) : System
fileName string
return System

deleteTemplate() public method

public deleteTemplate ( long dataStrctureId ) : void
dataStrctureId long
return void

getOrderedVariables() public method

public getOrderedVariables ( StructuredDataStructure structuredDataStructure ) : List
structuredDataStructure StructuredDataStructure
return List

getOrderedVariables() public method

public getOrderedVariables ( long dataStructureID, List Variables ) : List
dataStructureID long
Variables List
return List