SheetOpenTableByDefinedName Method (String, Int32, Int32, Boolean) |
Opens the table with specified name that defined in Excel and returns a table object.
Namespace: Aceoffix.ExcelWriterAssembly: Aceoffix (in Aceoffix.dll) Version: 5.0.0.1
Syntaxpublic Table OpenTableByDefinedName(
string DefinedName,
int RowCount,
int ColCount,
bool AutoIncrease
)
Public Function OpenTableByDefinedName (
DefinedName As String,
RowCount As Integer,
ColCount As Integer,
AutoIncrease As Boolean
) As Table
Parameters
- DefinedName
- Type: SystemString
The name defined in Excel can be a global name or a local name. - RowCount
- Type: SystemInt32
The number of rows in the range specified by the DefinedName. - ColCount
- Type: SystemInt32
The number of columns in the range specified by the DefinedName. - AutoIncrease
- Type: SystemBoolean
This parameter is optional. The default value is true. Set the value to false when you do not want the table to expand new rows.
Return Value
Type:
TableReturn a Table object.
See Also