Products Downloads


French version


 

Adds a Comment comment to the active sheet, in the range specified in Range. The range must only contain a single cell.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_ADD_COMMENT Range Comment ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Comment

ALPHA(250) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Adjusts the width and height of the cells in the range in the active worksheet that is specified in Range, so that all the contents are visible.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_AUTO_FIT Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the border around the range in the active worksheet specified in Range, according to the following parameters:

LineStyle

style of the line forming the border,

Thickness

thickness of the outline.

 

Certain combinations of style (LineStyle) and thickness (Thickness) are incompatible.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_BORDER_AROUND Range LineStyle Thickness ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

LineStyle

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_LINE_STYLE_CONTINUOUS

the line will be unbroken,

_EXL_LINE_STYLE_DASH

the line will be made up of dashes,

_EXL_LINE_STYLE_DASH_DOT

the line will be made up of a series of dash-dot sequences,

_EXL_LINE_STYLE_DASH_DOT_DOT

the line will be made up of a series of dash-dot-dot sequences,

_EXL_LINE_STYLE_DOT

the line will be made up of dots,

_EXL_LINE_STYLE_DOUBLE

there will be a double line,

_EXL_LINE_STYLE_NONE

no outline (useful for deleting the outline),

_EXL_LINE_STYLE_SLANT_DASH_DOT

the line will be made up of a series of slant dash-dot sequences.

Thickness

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_LINE_THICKNESS_HAIRLINE

extremely thin line,

_EXL_LINE_THICKNESS_THIN

thin line,

_EXL_LINE_THICKNESS_MEDIUM

medium line,

_EXL_LINE_THICKNESS_THICK

thick line.

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

* Setting the border

LineStyle = _EXL_LINE_STYLE_CONTINUOUS

Thickness =  _EXL_LINE_THICKNESS_MEDIUM

Range = 'B13:D22'

CALL_METHOD EXCEL_CLI RANG_BORDER_AROUND RANGE -

LINESTYLE THICKNESS RETURN_CODE

 

 

Calculates the range in the active worksheet specified in Range.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_CALCULATE Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Clears the active worksheet's range of cells specified in Range. All values, formulae, comments and formats will be erased.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_CLEAR Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Clears any comments in the range in the active worksheet specified in Range.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_CLEAR_COMMENTS Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Clears the values and formulae in the range in the active worksheet specified in Range.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_CLEAR_CONTENTS Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Clears the editing formats for the range in the active worksheet specified in Range.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_CLEAR_FORMATS Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Allows or prevents the text size from being reduced to make it completely visible within the cells in the range in the active worksheet specified in Range, depending on the value of the GrantedShrinkage parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_ENABLE_SHRINKAGE Range GrantedShrinkage ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

GrantedShrinkage

BOOL type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Allows or prevents line of text from being wrapped onto the line of text in range in the active worksheet specified in Range, depending on the value of the GrantedWrap parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

Syntax

CALL_METHOD NameExcelClientObject RANG_ENABLE_WRAP_TEXT Range GrantedWrap ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

GrantedWrap

BOOL type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Returns the address of the range specified in Range in the parameter Address, according to the following parameters:

AbsoluteRowReference

sets or disables absolute references for rows,

AbsoluteColumnReference

sets or disables absolute references for columns,

ReferenceStyle

address referencing style,

ExternalReference

indicates whether there is an external reference,

ReferenceRange

indicates any reference range.

 

The language used will be English.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_GET_ADDRESS Range AbsoluteRowReference AbsoluteColumnReference ReferenceStyle ExternalReference ReferenceRange Address ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

AbsoluteRowReference

BOOL type (input parameter)

AbsoluteColumnReference

BOOL type (input parameter)

ReferenceStyle

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_REFERENCE_STYLE_A1

the reference style is A1,

_EXL_REFERENCE_STYLE_R1C1

the reference style is R1C1.

ExternalReference

BOOL type (input parameter)

ReferenceRange

ALPHA(200) type (input parameter)

Address

ALPHA(200) type (output parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Returns the address of the range specified in Range in the parameter Address, according to the following parameters:

AbsoluteRowReference

sets or disables absolute references for rows,

AbsoluteColumnReference

sets or disables absolute references for columns,

ReferenceStyle

address referencing style,

ExternalReference

indicates whether there is an external reference,

ReferenceRange

indicates any reference range.

 

The language used will be that of the version of Microsoft Excel installed.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_GET_ADDRESS_LOCAL Range AbsoluteRowReference AbsoluteColumnReference ReferenceStyle ExternalReference ReferenceRange Address ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

AbsoluteRowReference

BOOL type (input parameter)

AbsoluteColumnReference

BOOL type (input parameter)

ReferenceStyle

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_REFERENCE_STYLE_A1

the reference style is A1,

_EXL_REFERENCE_STYLE_R1C1

the reference style is R1C1.

ExternalReference

BOOL type (input parameter)

ReferenceRange

ALPHA(200) type (input parameter)

Address

ALPHA(200) type (output parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

Note: This method is not implemented by the Cloud generator.

 

Returns the background color for the range in the active worksheet specified in Range, according to the value of the RGBValue parameter. This value is calculated using the formula B*65536+G*256+R (where B, G and R represent the values of the Blue, Green and Red components, respectively; these values must lie in the range 0 to 255).

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_GET_BACKGROUND_COLOR Range RGBValue ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

RGBValue

NUM_BIN_4 type (output parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Fills the VarOrArray variable or array with the values of the cells in the range in the active worksheet specified in Range. Cells are read from left to right and from top to bottom.

The number of cells to be returned is specified in the NbElements parameter.

The valid types for the values of the cells in the range Range are NUM_BIN_2, NUM_BIN_4, ALPHA(n), NUM_E, NUM_P, BOOL, DATE, TIME and TIMESTAMP. Where the TIMESTAMP type is used, any fractions of seconds are discounted.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_GET_VALUES Range VarOrArray NbElements ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

VarOrArray

one or two-dimension variable or array (output parameter)

NbElements

NUM_BIN_4 type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Justifies the text in the range in the active worksheet specified in Range.

If the range is too small to contain all the text, Microsoft Excel will display a message informing you that the text will overrun. If you click on OK, the justified text will replace the contents of the cells outside the selected range. To prevent this message from appearing, work with the method APPL_DISPLAY_ALERTS set to "*FALSE".

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_JUSTIFY Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Merges the cells of the range specified in Range, according to the value of the MergePerRow parameter.

If MergePerRow is set to *TRUE, the merge creates one cell per line; otherwise it creates one cell which replaces all the cells of the range. When several cells in the range contain data, an alert message appears, requesting confirmation for merging. If the merge is confirmed, only the data in the top-left cell is retained. If you do not want the message to appear, the APPL_DISPLAY_ALERTS method must be set to *FALSE.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_MERGE Range MergePerRow ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

MergePerRow

BOOL type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the background color for the range in the active worksheet specified in Range, according to the value of the RGBValue parameter. This value is calculated using the formula B*65536+G*256+R (where B, G and R represent the values of the Blue, Green and Red components, respectively; these values must lie in the range 0 to 255).

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_BACKGROUND_COLOR Range RGBValue ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

RGBValue

NUM_BIN_4 type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the width of the columns in the range in the active worksheet specified in Range, according to the value of the Width parameter. The unit of width is equal to the width of a character shown in the Normal style. With proportional fonts, the width of the  0 (zero) character will be used as the basis.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_COLUMN_WIDTH Range Width ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Width

NUM_BIN_4 type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the editing format given in the Format parameter for all the cells in the range in the active worksheet specified in Range.

In Windows generation, the format language is that of the version of Microsoft Excel installed.

In Cloud generation, the language is English.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_EDITION_FORMAT_LOCAL Range Format ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Format

ALPHA(250) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

* Formatting the date: January 1, 2004

Format = 'mmmm d yyyy'

CALL_METHOD EXCEL_CLI RANG_SET_EDITION_FORMAT_LOCAL -

RANGE FORMAT RETURN_CODE

* Defining the format: sign is displayed, positive values in blue, negative values in red

.......

Format = '[Red]+0,00;[Blue]-0,00'

CALL_METHOD EXCEL_CLI RANG_SET_EDITION_FORMAT_LOCAL -

RANGE FORMAT RETURN_CODE

 

 

Sets the font and format for the text in the range in the active worksheet specified in Range, according to the values of the parameters FontName and Size (Size of the characters, expressed in points).

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_FONT Range FontName Size ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

FontName

ALPHA(250) type (input parameter)

Size

NUM_E(6,2) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the font color for the range in the active worksheet specified in Range, according to the value of the RGBValue parameter. This value is calculated using the formula B*65536+G*256+R (where B, G and R represent the values of the Blue, Green and Red components, respectively; these values must lie in the range 0 to 255).

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_FONT_COLOR Range RGBValue ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

RGBValue

NUM_BIN_4 type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the position of the font for the range in the active worksheet specified in Range to the value of the FontLocation parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_FONT_LOCATION Range FontLocation ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

FontLocation

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_TEXT_LOCATION_SUBSCRIPT

the text will be shown in subscript,

_EXL_TEXT_LOCATION_SUPERSCRIPT

the text will be shown in superscript,

_EXL_TEXT_LOCATION_BASELINE

the text will be shown on the baseline.

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the styles for the font for the range in the active worksheet specified in Range, according to the following parameters:

Bold

indicates whether or not the font is shown in bold,

Italic

indicates whether or not the font is shown in italics,

StrikeThrough

indicates whether or not the font is struck through,

UnderlineStyle

font underline style.

 

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_FONT_STYLES Range Bold Italic StrikeThrough UnderlineStyle ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Bold

BOOL type (input parameter)

Italic

BOOL type (input parameter)

Strikethrough

BOOL type (input parameter)

UnderlineStyle

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_UNDERLINE_NONE

no underline,

_EXL_UNDERLINE_SINGLE

single underline,

_EXL_UNDERLINE_DOUBLE

double underline,

_EXL_UNDERLINE_SINGLE_ACCOUNT

single account underline,

_EXL_UNDERLINE_DOUBLE_ACCOUNT

double account underline.

ReturnCode

NUM_BIN_4 type (output parameter)

* Defining the range

Range = 'C' // row

Bold = *TRUE

Italic = *FALSE

Strikethrough = *FALSE

UnderlineStyle = _EXL_UNDERLINE_NONE

CALL_METHOD EXCEL_CLI RANG_SET_FONT_STYLES -

RANGE BOLD ITALIC STRIKETHROUGH UNDERLINESTYLE RETURN_CODE

 

 

Sets a Formula formula for all the cells in the range in the active worksheet specified in Range.

The language used for the formula will be English and the A1 referencing style used.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_FORMULA Range Formula ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Formula

ALPHA(500) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

* Calculating the difference between two weight measures from

* cells C13 to C22. The difference is presented from cell D14 to D22.

* Defining the cell range.

OriginRow = 14

DestRow = OriginRow + 9 - 1

* Column for the differences (differences of weight C14 - C13)

Range = 'D' // OriginRow // ':D' // DestRow

Formula = '=C14-C13'

CALL_METHOD EXCEL_CLI RANG_SET_FORMULA -

RANGE FORMULA RETURN_CODE

* Defining the format: sign is displayed, positive values in blue, negative values in red

Format = '[Red]+0,00;[Blue]-0,00'

CALL_METHOD EXCEL_CLI RANG_SET_EDITION_FORMAT_LOCAL -

RANGE FORMAT RETURN_CODE

......

* Summing up differences

* Total of differences = sum of cells D14:D22

Range = 'D' // Row

Formula = '=SUM(D' // DestRow // ':D' // OriginRow // ')'

CALL_METHOD EXCEL_CLI RANG_SET_FORMULA -

RANGE FORMULA RETURN_CODE

*

 

 

Sets a Formula formula for all the cells in the range in the active worksheet specified in Range.

An Excel formula is always preceded by the character "=".

The Formula parameter may contain something other than an Excel formula. For example, it may contain a string in date, time or numeric format.

In Windows generation, the formula language is that of the version of Microsoft Excel installed.

In Cloud generation, if the Formula parameter contains an Excel formula, the language is English (e.g. =SUM(A1:A4)). For strings representing a date, time or other variable, the format is that of the browser language.

The reference style is A1.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

 

CALL_METHOD NameExcelClientObject RANG_SET_FORMULA_LOCAL Range Formula ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Formula

ALPHA(500) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

Note: This method is not implemented by the Cloud generator.

 

Sets Formula a formula for all the cells in the range in the active worksheet specified in Range.

The language used for the formula will be that of the version of Microsoft Excel installed and the R1C1 referencing style will be used.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

 

CALL_METHOD NameExcelClientObject RANG_SET_FORMULA_LOCAL_R1C1 Range Formula ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Formula

ALPHA(500) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

Note: This method is not implemented by the Cloud generator.

 

Sets a Formula formula for all the cells in the range in the active worksheet specified in Range.

The language used for the formula will be English and the R1C1 referencing style used.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_FORMULA_R1C1 Range Formula ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Formula

ALPHA(500) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

Note: This method is not implemented by the Cloud generator.

 

Sets the horizontal alignment of the text in the range in the active worksheet specified in Range, according to the value of the Alignment parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_HORIZONTAL_ALIGNMENT Range Alignment ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Alignment

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_HALIGN_GENERAL

the text will be located on the left of the cell.

_EXL_HALIGN_LEFT

the text will be located on the left of the cell.

_EXL_HALIGN_RIGHT

the text will be located on the right of the cell.

_EXL_HALIGN_CENTER

the text will be horizontally centered in the cell.

_EXL_HALIGN_JUSTIFY

the text will appear over several lines against the vertical sides of the cell.

_EXL_HALIGN_CENTER_ACROSS_SEL

the text will appear centered with respect to the various columns forming the range.

ReturnCode

NUM_BIN_4 type (input parameter)

 

 

* Right alignment

Alignment = _EXL_HALIGN_RIGHT

CALL_METHOD EXCEL_CLI RANG_SET_HORIZONTAL_ALIGNMENT -

RANGE ALIGNMENT RETURN_CODE

 

 

Sets the name associated with the range in the active worksheet specified in Range, assigning the value of the Name parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_NAME Range Name ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Name

ALPHA(250) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the orientation of the text in the cells in the range in the active worksheet specified in Range, assigning the value of the Orientation parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

 

CALL_METHOD NameExcelClientObject RANG_SET_ORIENTATION Range Orientation ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Orientation

NUM_BIN_4 type (input parameter)

Possible values:

Integer in the range 90 to +90

angle of orientation of the text, in degrees, relative to the horizontal,

_EXL_ORIENTATION_HORIZONTAL

standard orientation,

_EXL_ORIENTATION_VERTICAL

the letters will be placed one below the other,

_EXL_ORIENTATION_UPWARD

the words will be written along a vertical axis, from bottom to top,

_EXL_ORIENTATION_DOWNWARD

the words will be written along a vertical axis, from top to bottom.

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Sets the height of the rows in the range in the active worksheet specified in Range, according to the value of the Height parameter. The unit of height is the point, which equals 1/72 of an inch (approx. 0.035 cm).

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_ROW_HEIGHT Range Height ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Height

NUM_BIN_4 type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Fills the range of cells in the active worksheet specified in Range, according to the following parameters:

VarOrArray

Variable or one or two dimension array containing the values to be used to fill the cells in the Range range.
The valid types for these values are NUM_BIN_2, NUM_BIN_4, ALPHA(n), NUM_E, NUM_P, BOOL, DATE, TIME and TIMESTAMP.
Where the TIMESTAMP type is used, any fractions of seconds are discounted.

NbElements

Number of elements to be taken into account when filling the range.

 

The range will be filled from left to right and from top to bottom.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_SET_VALUES Range VarOrArray NbElements ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

VarOrArray

one or two-dimension variable or array (input parameter)

NbElements

NUM_BIN_4 type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

Example >>

 

Sets the vertical alignment of the text in the range in the active worksheet specified in Range, according to the value of the Alignment parameter.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

 

CALL_METHOD NameExcelClientObject RANG_SET_VERTICAL_ALIGNMENT Range Alignment ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

Alignment

NUM_BIN_4 type (input parameter)

Possible values:

_EXL_VALIGN_BOTTOM

the text will be located at the bottom of the cell,

_EXL_VALIGN_CENTER

the text will be located midway up the cell,

_EXL_VALIGN_TOP

the text will be located at the top of the cell,

_EXL_VALIGN_JUSTIFY

the text will appear over several lines against the horizontal sides of the cell.

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

Splits in individual cells a range of cells which have been merged.

The ReturnCode parameter will be set to "0" if the method was executed successfully, and to a value other than "0" in the event of a problem.

 

Syntax

CALL_METHOD NameExcelClientObject RANG_UN_MERGE Range ReturnCode

Parameters

Range

ALPHA(200) type (input parameter)

ReturnCode

NUM_BIN_4 type (output parameter)

 

 

 

 

↑ Top of page