Click or drag to resize

IGoExcel Methods

The IGoExcel type exposes the following members.

Methods
  NameDescription
Public methodChangeSourceOfLinked
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.
Public methodClearCache
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.
Public methodClose
Closes the Excel file that is currently open (if any).
Public methodCurrentRowValue
Gets the value of the cell at the specified column in the current row. (Use FindRow to set the current row.)
Public methodFindColumn
Find a column by name. The name is the value of the cell in the TitleRow.
Public methodFindRow
Finds and selects a row that matches the given values.
Public methodOpen
Opens the specified Excel workbook, and optionally sets the named worksheet as the current sheet.
Public methodSave
Saves the Excel file that is currently open (if any).
Public methodSetCurrentSheet
Sets the current sheet of the specified Excel workbook.
Top
See Also