Excel - How to
use
Examples
You can use this
command to
transfer data to
and from your Excel spreadsheets.
Note: This feature is supported only in Microsoft Office 2000 and above.
It provides following commands:
- Open Spreadsheet
This command is used to open an excel
spreadsheet. You can also specify the session name and/or sheet name if your
task involves working with many excel sheets and workbooks.
- Close Spreadsheet
This
command matches the Open Spreadsheet command. It closes
the spreadsheet opened by the Open Spreadsheet command. It
identifies the spreadsheet with the session name provided at the time of using the 'Open Spreadsheet' command.
- Get Cells
Using this command, you can fetch the value(s)
of the active/specific cell as well as for a range of cells from the
spreadsheet opened by the Open Spreadsheet command. When you fetch values for an
active/specific cell, you can assign its value to a variable from the list. However,
when fetching values for multiple cells, the value is assign to the
system variable $Excel Column (index)$ which you can use in 'Loop for each row in an Excel Dataset'.
- Set Cells
Using this command, You can set the value for the active or a
specific cell in the excel spreadsheet opened by the Open Spreadsheet command. You can also input the value of a variable in the sheet.
- Go to Cell
Using this command, you can go to a
specific cell or one cell left/right/above/below of the active cell or at the
beginning/end of the row/column in the excel spreadsheet opened by the
Open Spreadsheet command.
- Run Excel Macro
Using this command option,
you can run the excel macro which is stored in the excel spreadsheet opened by the Open Spreadsheet command.
- Delete Cells
This command is used to delete values in the active/specific cell in the excel spreadsheet opened by the
Open Spreadsheet command.
