Excel

CopyTextToClipboard, Excel_Close, Excel_GetValue, Excel_GetValueEx, Excel_Open, Excel_Paste, Excel_PasteEx, Excel_Save, Excel_SetValue, Excel_SetValueEx

CopyTextToClipboard

Description

 CopyTextToClipboard(
    Text
);

Copies the specified text to clipboard.

Parameters

Text

Text that will be copied to the clipboard.

Excel_Close

Description

 Excel_Close();

This function closes the Excel file previously opened by the Excel_Open function.

Note

This function doesn't save changes made in the Excel file. Changes in the Excel file can be saved by the Excel_Save function.

See Also
Excel_Open, Excel_Save

Excel_GetValue

Description

 Excel_GetValue(
    ExcelCell,
    ExcelValue
);

This function gets text value from specified Excel sheet cell.

Parameters

ExcelCell

Cell coordinates (e.g. “A1”, “C12”, ...)

ExcelValue

Buffer for cell text value

See Also
Excel_GetValueEx, Excel_SetValue

Excel_GetValueEx

Description

 Excel_GetValueEx(
   int  ExcelColumn,
   int  ExcelRow,
    ExcelValue
);

This function gets the text value from specified Excel sheet cell.

Parameters

int ExcelColumn

Cell column is number between 0 and maximal column count-1

int ExcelRow

Cell row is number between 0 and maximal row count-1

ExcelValue

Buffer for cell text value

See Also
Excel_GetValue, Excel_SetValue

Excel_Open

Description

 Excel_Open(
    ExcelFilename,
   int  ExcelSheet,
   int  ExcelShow
);

This function opens an Excel file, selects the specified sheet and possibly shows the Excel window.

Parameters

ExcelFilename

Full path of the opened Excel file. If ExcelFilename is NULL, new Excel file with default number of Excel sheets will be created.

int ExcelSheet

This parameter is a number between 1 and number of Excel sheets in opened Excel file. Excel sheet with specified index will be selected and used.

int ExcelShow

Show/hide window with opened Excel file.

1	Show Excel window
0	Hide Excel window

Note

Only one Excel file can be opened at the same time. Opened Excel file must be closed before another Excel file can be opened.

See Also
Excel_Save, Excel_Close

Excel_Paste

Description

 Excel_Paste(
    ExcelCell
);

This function pastes the text value from clipboard to the specified Excel sheet cell.

Parameters

ExcelCell

Cell coordinates (e.g. “A1”, “C12”, ...)

See Also
Excel_PasteEx

Excel_PasteEx

Description

 Excel_PasteEx(
   int  ExcelColumn,
   int  ExcelRow
);

This function pastes the text value from clipboard to the specified Excel sheet cell.

Parameters

int ExcelColumn

Cell column is number between 0 and maximal column count-1

int ExcelRow

Cell row is number between 0 and maximal row count-1

See Also
Excel_Paste

Excel_Save

Description

 Excel_Save();

This function saves changes made in the opened Excel file.

See Also
Excel_SetValue, Excel_Paste

Excel_SetValue

Description

 Excel_SetValue(
    ExcelCell,
    ExcelValue
);

This function sets a text value to the specified Excel sheet cell.

Parameters

ExcelCell

Cell coordinates (e.g. “A1”, “C12”, ...)

ExcelValue

Cell text value (e.g. “97”, “28.2.2005”, ...)

See Also
Excel_SetValueEx, Excel_GetValue

Excel_SetValueEx

Description

 Excel_SetValueEx(
   int  ExcelColumn,
   int  ExcelRow,
    ExcelValue
);

This function sets a text value to the specified Excel sheet cell.

Parameters

int ExcelColumn

Cell column is number between 0 and maximal column count-1

int ExcelRow

Cell row is number between 0 and maximal row count-1

ExcelValue

Cell text value (e.g. “97”, “28.2.2005”, ...)

See Also
Excel_SetValue, Excel_GetValue

Excel🔗

Note

Note

Excel