Products Downloads


French version


 

 

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

 

↑ Top of page


  • Aucune étiquette