Warning: This function is ignored in Adelia Cloud generation.
RDC |
.NET |
X |
X |
This function is used to get the current values of the options linked to export in Excel format.
Parameters
Note: the parameters MaintainColumnAlignment, MaintainRelativeObjectPosition, ExportPageAreaPair, UseFormatInDataOnly, ExportImagesInDataOnly, UseTabularFormat and UseWorksheetFunctions are not supported by SDK .NET.
NUM_BIN_4 |
ConstantColumnWidth |
(O) |
0=False 1=True. |
NUM_E(10,2) |
ColumnSize |
(O) |
Size of the column in points. |
NUM_BIN_4 |
AreaType |
(O) |
Type of the reference area to calculate the columns' size (if the size is not constant). 1=Report header 2=Page header 3=Group header 4=Detail 5=Group footer 6=Page footer 7=Report footer |
NUM_BIN_4 |
AreaGroupNumber |
(O) |
Group number if AreaType equals 3 or 5. |
NUM_BIN_4 |
MaintainColumnAlignment |
(O) |
Maintains columns aligned. 0=False, 1=True. |
NUM_BIN_4 |
MaintainRelativeObjectPosition |
(O) |
Maintains the objects' relative position. 0=False, 1=True. |
NUM_BIN_4 |
ShowGridlines |
(O) |
Shows grid lines. 0=False, 1=True. |
NUM_BIN_4 |
ChopPageHeader |
(O) |
Simplification of the page header. 0=False, 1=True. |
NUM_BIN_4 |
ConvertDateToString |
(O) |
Converts dates into strings. 0=False, 1=True. |
NUM_BIN_4 |
ExportPageAreaPair |
(O) |
Display frequency of the pair (header, footer). 0=Never, 1=Once by report, 2=Once by page. |
NUM_BIN_4 |
PageBreaks |
(O) |
Creates page break for each page. 0=False, 1=True. |
NUM_BIN_4 |
TabHasColumnHeadings |
(O) |
Column header for tabs. 0=False, 1=True. |
NUM_BIN_4 |
UseFormatInDataOnly |
(O) |
Exports attributes in the data format only. 0=False, 1=True. |
NUM_BIN_4 |
ExportImagesInDataOnly |
(O) |
Exports images in the data format only. 0=False, 1=True. |
NUM_BIN_4 |
UseTabularFormat |
(O) |
Use of tabular format. 0=False, 1=True. |
NUM_BIN_4 |
UseWorksheetFunctions |
(O) |
Use of functions for subtotals. 0=False, 1=True. |
Example
[DECL_PGM]
NUM_BIN_4 xlsAreaType
NUM_BIN_4 xlsAreaGroupNumber
NUM_BIN_4 xlsChopPageHeader
NUM_E(10,2) xlsConstantColumnWidth
NUM_BIN_4 xlsConvertDateToString
NUM_BIN_4 xlsExportImagesInDataOnly
NUM_BIN_4 xlsExportPageAreaPair
NUM_BIN_4 xlsMaintainColumnAlignment
NUM_BIN_4 xlsMaintainRelativeObjectPosition
NUM_BIN_4 xlsPageBreaks
NUM_BIN_4 xlsTabHasColumnHeadings
NUM_BIN_4 xlsUseConstantColumnWidth
NUM_BIN_4 xlsUseFormatInDataOnly
NUM_BIN_4 xlsUseTabularFormat
NUM_BIN_4 xlsUseWorksheetFunctions
NUM_BIN_4 xlsShowGridlines
[INIT_PGM]
LOAD_DLL 'vaCrysRt.dll'
/* Retrieves options' values for the export format XLS
CALL_DLL 'VaCrysRt' 'VaGetExcelInfos' xlsUseConstantColumnWidth xlsConstantColumnWidth xlsAreaType xlsAreaGroupNumber xlsMaintainColumnAlignment xlsMaintainRelativeObjectPosition xlsShowGridlines xlsChopPageHeader xlsConvertDateToString xlsExportPageAreaPair xlsPageBreaks xlsTabHasColumnHeadings xlsUseFormatInDataOnly xlsExportImagesInDataOnly xlsUseTabularFormat xlsUseWorksheetFunctions