IGoExcel Properties |
The IGoExcel type exposes the following members.
Name | Description | |
---|---|---|
Application |
Gets the Excel Application object (of the type Microsoft.Office.Interop.Excel.Application).
| |
CellValueString |
Gets or sets the value of the cell at the specified address in the current workbook and worksheet.
| |
CellValueString, String, String |
Gets or sets the value of the cell at the specified address.
| |
CellValuesString, String |
Gets or sets the values of a range of cells from a single column or row.
| |
CellValuesString, String, String, String |
Gets or sets the values of a range of cells from a single column or row.
| |
DisplayAlerts |
Gets or sets a property of the Excel application. If this is True, alert dialogs will be displayed.
| |
FindRowStart |
Gets or sets the index (1-based) of the first row to search wit hthe FindRow function. This must be creater than the TitleRow.
The default value is 2.
| |
NamedRangeValue |
Gets or sets the value of a named range. Named ranges are defined in the Excel file.
| |
TitleRow |
Gets or sets the index (1-based) of the title row. The title row is the row that contains the column names.
The default value is 1.
| |
Tolerance |
Gets or sets a value that is used for numeric equality tests in the FindRow function.
If the difference between two numbers is less than or equal to the tolerance, they will be considered to be equal.
The default tolerance is 0.0000001.
|