| int excel_select_range(string rangename) |
To select a cell or group of cells in the current Excel spreadsheet |
| int excel_putstrvalue(string svalue) | Record into the current table cell Excel a text value |
| int excel_putnumvalue(string svalue) | Record into the current table cell, Excel numeric value |
| int excel_attach() | Attaching to current instance Excel |
| int excel_detach() | Detach Excel |
| int excel_request(string command,string par1,string par2, srting par3); | To execute a command with parameters |
| string excel_getstrvalue(); | Consider the text value of the current cell in Excel |
| double excel_getnumvalue(); | Consider the numeric value of the current cell in Excel |
excel_request
excel_request("range_copy");
Copies the buffer contents of the current cell together with the cell format (color, font, etc.).
excel_request("range_paste");
Inserts into the current position cell contents that have been copied by the previous command.
excel_request("set_borders");
excel_request("set_borders", int left, int top, int right, int bottom);
To create a frame around the selected cell.
If the function has no arguments, then a full frame is drawn.
If arguments are given, then according to their values (1/0), the frame line is drawn or not.
excel_request("set_column_width", string letter_column, string width);
To set column width in Excel.
letter_column is the drive letter of the column (In column B, "B:D" - columns B through D);
width - the width of the cell.
excel_request("workbook_select", string workbook_name);
Make current file workbook_name.
excel_request("sheet_select", string sheet_name);
To make the current table sheet_name current file.
If sheet_name is "", the new empty table will be added.
excel_request("set_backcolor", string excel_color);
To set the background color of the current cell of the Excel spreadsheet:
| "lightgreen" | light green |
| "yellow" | yellow |
| "red" | red |
| "orange" | orange |
| "green" | green |
| "blue" | blue |
| "lightgray" | light gray |
| "gray" | gray |
| "darkgray" | dark gray |
excel_request("put_selection_values",...)
Set the values for the current Excel selection.
In the arguments, the enumeration specifies the names of the Excel selection variables and the values to be assigned.
Arguments can be listed in any composition and order.
The argument names and their values correspond to the names and values that Excel applies to its macros.
Parameter "VerticalAlignment" - vertical alignment.
| top | -4160 |
| center | -4108 |
| bottom | -4107 |
Parameter "HorizontalAlignment" - horizontal alignment.
| left | -4131 |
| center | -4108 |
| right | -4152 |
| by value | 1 |
Parameter "WrapText" - wrap text by words (0/1).
Parameter "Orientation" - text orientation.
| horizontal | -4128 |
| vertical | -4171 |
Parameter "IndentLevel" - offset in Selection from margin (float number).
Parameter "NumberFormat" - format value in Selection (for example for show float number with 2 presicion - "0,00")
excel_request("put_selection_fontvalues"...)
Set the font values for the current Excel selection area.
In the arguments, the enumeration specifies the names of the Excel selection variables and the values to be assigned.
Arguments can be listed in any composition and order.
The argument names and their values correspond to the names and values that Excel uses in their macros to set font properties in the selected cell or group of selected cells.
Parameter "Name" - font name (text field, for example "Arial Narrow").
Parameter "Size" - font size (numeric value).
Parameter "Bold" - bold garniture (0/1).
Parameter "Italic" - italic garniture (0/1).
Paremeter "Color" - font color (numeric value).
Example 1.
excel_request("put_selection_fontvalues","Name","Arial Narrow","Size",12,"Bold",0,"Italic",0,"Color",0); // set font name Arial, size = 12, no bold, no italic, black
Example 2
excel_request("put_selection_fontvalues","Size",12); // set font size = 12
excel_request ("selection_varvalues", ...
Learn the formatting values for the current Excel selection
Format of treatment
excel_request ("selection_varvalues", int & vertical_alignment, int & horizontal_alighnment, int & wrap_text, int & orientation, int & hor_allign_offset, string & numformat);
Variables write the values of formatting variables from the current cell, or a selected group of Excel cells.
excel_request ("selection_font_varvalues", ...
Find the values of the current font in the current Excel selection
Format of treatment
excel_request ("selection_font_varvalues", string & fontname, int & Size, int & Bold, int & Italic, int & Strikethrough, int & superscript, int & subscript)
