Methods of the EXCEL CLIENT Object - Prefix RANG

RANG_ADD_COMMENT

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)

RANG_AUTO_FIT

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)

RANG_BORDER_AROUND

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)

Example:

* 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

RANG_CALCULATE

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)

RANG_CLEAR

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)

RANG_CLEAR_COMMENTS

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)

RANG_CLEAR_CONTENTS

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)

RANG_CLEAR_FORMATS

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)

RANG_ENABLE_SHRINKAGE

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)

RANG_ENABLE_WRAP_TEXT

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)

RANG_GET_ADDRESS

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)

RANG_GET_ADDRESS_LOCAL

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.

RANG_GET_BACKGROUND_COLOR

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)

RANG_GET_VALUES

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)

RANG_JUSTIFY

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)

RANG_MERGE

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)

RANG_SET_BACKGROUND_COLOR

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)

RANG_SET_COLUMN_WIDTH

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)

RANG_SET_EDITION_FORMAT_LOCAL

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)

Example:

* 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

RANG_SET_FONT

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)

RANG_SET_FONT_COLOR

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)

RANG_SET_FONT_LOCATION

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)

RANG_SET_FONT_STYLES

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)

Example:

* 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

RANG_SET_FORMULA

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)

Example:

* 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

*

RANG_SET_FORMULA_LOCAL

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.

RANG_SET_FORMULA_R1C1

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.

RANG_SET_FORMULA_R1C1_LOCAL

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_R1C1_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.

RANG_SET_HORIZONTAL_ALIGNMENT

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)

Example:

* Right alignment

Alignment = _EXL_HALIGN_RIGHT

CALL_METHOD EXCEL_CLI RANG_SET_HORIZONTAL_ALIGNMENT -

RANGE ALIGNMENT RETURN_CODE

RANG_SET_NAME

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)

RANG_SET_ORIENTATION

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)

RANG_SET_ROW_HEIGHT

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)

RANG_SET_VALUES

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 >>

RANG_SET_VERTICAL_ALIGNMENT

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)

RANG_UN_MERGE

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)