Click or drag to resize
SheetOpenTable Method (String, Boolean)
Opens the specified range of cells and returns a Table object.

Namespace: Aceoffix.ExcelWriter
Assembly: Aceoffix (in Aceoffix.dll) Version: 5.0.0.1
Syntax
public Table OpenTable(
	string RangeAddress,
	bool AutoIncrease
)

Parameters

RangeAddress
Type: SystemString

The A1-style notation is defined in Microsoft Excel. For example: A1:F8, it means a range of cells A1 through F8. The A1 cell is the cell whose row index is 1 and column index is 1. The F8 cell is the cell whose row index is 8 and column index is 6.

Note Note

Note: There is a limit that the maximum number of columns per worksheet is 676 and the maximum number of rows is 65,536 in Excel2003 and earlier versions. Please do not exceed the maximum number of columns when input the parameter of RangeAddress.

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: Table
Returns a Table object.
Remarks

Please refer to the full code example in the OpenTable(String) method topic to learn how to call the OpenTable method.

See Also