- rang_clear
- rang_clear_comments
- rang_clear_contents
- rang_clear_formats
- rang_enable_shrinkage
- rang_enable_wrap_text
- rang_get_address
- rang_get_address_local
- rang_get_background_color
- rang_get_values
- rang_justify
- rang_merge
- rang_set_background_color
- rang_set_column_width
- rang_set_edition_format_local
- rang_set_font
- rang_set_font_color
- rang_set_font_location
- rang_set_font_styles
- rang_set_formula
- rang_set_formula_local
- rang_set_formula_local_r1c1
- rang_set_formula_r1c1
- rang_set_horizontal_alignment
- rang_set_name
- rang_set_orientation
- rang_set_row_height
- rang_set_values
- rang_set_vertical_alignment
- rang_un_merge
- excelclientpref
- rang_add_comment
- rang_auto_fit
- rang_border_around
- rang_calculate
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:
|
||||||||||||||||
Thickness |
NUM_BIN_4 type (input parameter) Possible values:
|
||||||||||||||||
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:
|
||||
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:
|
||||
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:
|
||||||
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:
|
||||||||||
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_LOCAL_R1C1
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.
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_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:
|
||||||||||||
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:
|
||||||||||
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. |
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) |
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:
|
||||||||
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) |
See also...