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).
|