C# Class BExIS.RPM.Output.ExcelTemplateProvider

ファイルを表示 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