Warning: This function is ignored in Adelia Cloud generation.
RDC |
.NET |
X |
X |
This function is used to set 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 |
(I) |
0=False 1=True -1=Unchanged |
NUM_E(10,2) |
ColumnSize |
(I) |
Size of the column in points: -1.0=Unchanged. |
NUM_BIN_4 |
AreaType |
(I) |
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 -1=Unchanged. |
NUM_BIN_4 |
AreaGroupNumber |
(I) |
Group number if AreaType equals 3 or 5 -1=Unchanged. |
NUM_BIN_4 |
MaintainColumnAlignment |
(I) |
Maintains columns aligned: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
MaintainRelativeObjectPosition |
(I) |
Maintains the objects' relative position: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
ShowGridlines |
(I) |
Shows grid lines: 0=False, 1=True. |
NUM_BIN_4 |
ChopPageHeader |
(I) |
Simplification of the page header: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
ConvertDateToString |
(I) |
Converts dates into strings: 0=False 1=True |
NUM_BIN_4 |
ExportPageAreaPair |
(I) |
Display frequency of the pair (header, footer): 0=Never 1=Once by report 2=Once by page -1=Unchanged. |
NUM_BIN_4 |
PageBreaks |
(I) |
Creates page break for each page: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
TabHasColumnHeadings |
(I) |
Column header for tabs: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
UseFormatInDataOnly |
(I) |
Exports attributes in the data format only: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
ExportImagesInDataOnly |
(I) |
Exports images in the data format only: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
UseTabularFormat |
(I) |
Use of tabular format: 0=False 1=True -1=Unchanged. |
NUM_BIN_4 |
UseWorksheetFunctions |
(I) |
Use of functions for subtotals: 0=False 1=True -1=Unchanged. |
The value –1 (or –1.0 for a real parameter) is used to leave a parameter's value unchanged.
Example
[INIT_PGM]
LOAD_DLL 'vaCrysRt.dll'
/* Sets the management options
CALL_DLL 'vaCrysRt.dll' 'VaSetCRManagement' *FALSE 29 0 /* 29: Excel format export
/* You can set the name and folder for the exported file: the suffix is given by the required file type
CALL_DLL 'vaCrysRt.dll' 'VaSetExportInfos' 'c:\tmp' 'EXPTXLS'
/* Sets the options' values for the XLS export format
/* Columns with a constant size [800 points]
/* Grid lines displayed
CALL_DLL 'VaCrysRt' 'VaSetExcelInfos' 1 800.0 -1 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1
/* Sets the options' values for the XLS export format
/* Columns with a size calculated regarding the objects in the detail area
/* Grid lines displayed
CALL_DLL 'VaCrysRt' 'VaSetExcelInfos' 0 -1.00 4 -1 -1 -1 1 -1 -1 -1 -1 -1 -1 -1 -1 -1