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