Attributes

Description

String LNCSrvAddr

The IPv4 address of the Launcher server 

Example:

192.168.1.3

String ToXls

Template name

Exemple:

C:\\temp\\template.xlsx

String ToSheet

Excel sheet name

String ToName

Area name into Excel sheet

String XlsOpt

Can take the following values :

•         *REPLACE : new data overwrites the old data.

•         *RESIZE : new data overwrites the old data. Area in the workbook is resized.

•         *ADD : new data is added to the old data.

•         *INSERT : rows are inserted to receive new data. The parameter ENTIRER determines whether entire lines are inserted or not.

•         *MAP : column values ​​from the data source are assigned to cells with the same names in the Excel spreadsheet. Only the first entry of the data source is used.

String NoData

Can take the following values :

•         *BLANK : if no data is present in the data source, the field is left empty

•         *DEL : if no data is present in the data source, the cells are removed

String XlsMap

Can take the following values :

•         *MAPNAME : column values ​​from the data source are assigned to cells with the same names in the Excel spreadsheet.

•         *MAPVALUE : values ​​for columns in the data source are assigned to cells whose initial value is the same

String ColPref

Can take the following values :

•         *NONE : no prefix for columns

•         Prefix value for columns

String DataSource

The full path of the CSV file if the DataSource class is not used.

String RecCnt

If using a CSV file directly as a source of data, it is mandatory to specify the number of rows in the CSV file. In all other cases, this attribute is not used.

String Entirer

Can take the following values :

•         True : entire lines are inserted

•         False : not inserting entire rows

String AutoFmt

Can take the following values :

•         *NONE : no automatic formatting is applied.

•         Format name : le specified format is applied.

String AutoFit

Can take the following values :

•         True : automatically adjust the column width.

•         False : no change of the column width

String FmtCells

Can take the following values :

•         True : the cell format is set according to the type Database.

•         False : the format of the cells is determined by Excel, according to the values.

String AddColH

Can take the following values :

•         True : column names are inserted in the first line.

•         False : column names are not inserted in the first line.

String Freeze

Can take the following values :

•         True : replaces the terms by their calculated value

•         False : none

String LocateSheet

Specifies the active sheet.

String LocateCell

Specifies the active cell.

DataSource sourceData

An instance of the DataSource class.

String Output

Can take the following values :

•         *PRINT : the document will be printed on the default printer.

String ShowDoc

Can take the following values :

•         True : to show the document

•         False : document not visible

String SavDoc

Complete path of the result document

Example:

C:\\temp\\result.xlsx

String SavFmt

Can take the following values  :

•         *NORMAL : format of the template file

•         *XLS : Excel format

•         *TXT : text format

String EndOpt

Can take the following values :

•         *NONE : no end processing option

•         *DOC : close Excel document

•         *ALL : end of the command session and closing Excel application

•         *APP : close Excel application

Attributes

Getters (read)

Setters (write)

String LNCSrvAddr

getLNCSrvAddr()

setLNCSrvAddr()

String ToXls

getToXls()

setToXls()

String ToSheet

getToSheet()

setToSheet()

String ToName

getToName()

setToName()

String XlsOpt

getXlsOpt()

setXlsOpt()

String NoData

getNoData()

setNoData()

String XlsMap

getXlsMap()

setXlsMap()

String ColPref

getColPref()

setColPref()

String DataSource

getDataSource()

setDataSource()

String RecCnt

getRecCnt()

setRecCnt()

String Entirer

getEntirer()

setEntirer()

String AutoFmt

getAutoFmt()

setAutoFmt()

String AutoFit

getAutoFit()

setAutoFit()

String FmtCells

getFmtCells()

setFmtCells()

String AddColH

getAddColH()

setAddColH()

String Freeze

getFreeze()

setFreeze()

String LocateSheet

getLocateSheet()

setLocateSheet()

String LocateCell

getLocateCell()

setLocateCell()

DataSource sourceData

getSourceData()

setSourceData()

String Output

getOutput()

setOutput()

String ShowDoc

getShowDoc()

setShowDoc()

String SavDoc

getSavDoc()

setSavDoc()

String SavFmt

getSavFmt()

setSavFmt()

String EndOpt

getEndOpt()

setEndOpt()