IGoExcel Methods |
The IGoExcel type exposes the following members.
Name | Description | |
---|---|---|
ChangeSourceOfLinked |
Replace the Excel file that is currently a source of linked parameters with another file.
This is similar to the Change Source command on the context menu in the UI.
| |
ClearCache |
Clear the internal cache used by FindRow and CurrentRowValue. This cache is not used by CellValue and related functions.
It is a global cache, and it persists when rules are not being run.
| |
Close |
Closes the Excel file that is currently open (if any).
| |
CurrentRowValue |
Gets the value of the cell at the specified column in the current row.
(Use FindRow to set the current row.)
| |
FindColumn |
Find a column by name. The name is the value of the cell in the TitleRow.
| |
FindRow |
Finds and selects a row that matches the given values.
| |
Open |
Opens the specified Excel workbook, and optionally sets the named worksheet as the current sheet.
| |
Save |
Saves the Excel file that is currently open (if any).
| |
SetCurrentSheet |
Sets the current sheet of the specified Excel workbook.
|