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.

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)