The IGoExcel type exposes the following members.
Methods
| 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(String) |
Find a column by name. The name is the value of the cell in the TitleRow.
|
| FindColumn(String, Int32) |
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.
|
| QuitApplication |
Quits the Excel application that is used by the GoExcel functions.
In most cases it is not necessary to call this function.
This should be called only if a rule has used the Excel API directly to change the Excel application state, and you don't want this state to carry forward into other rules.
Call this only as the last GoExcel function in a rule.
|
| Save |
Saves the Excel file that is currently open (if any).
|