Table Class

Table Class

Table class represents the Excel table object defined in Aceoffix.

Inheritance Hierarchy

SystemObject
Aceoffix.ExcelWriterTable

Namespace: Aceoffix.ExcelWriter
Assembly: Aceoffix (in Aceoffix.dll) Version: 5.0.0.1

Syntax

ASP.NET

Copy

public class Table

Public Class Table

The Table type exposes the following members.

Methods

	Name	Description
	Close	Closes the current Table.
	Merge	Creates a merged cell from the current Table.
	Merge(Boolean)	Creates a merged cell form the current Table or merges all columns in the Table into one column.
	NextRow	Moves to the next record row in the Table.

Top

Properties

	Name	Description
	BackColor	Sets the back color of the Table.
	Border	Gets the border object of the Table.
	ColumnWidth	Sets the width of all columns in the Table.
	DataFields	Gets a collection of DataFields of the current record.
	Font	Gets the font object.
	ForeColor	Sets the fore color of the Table.
	HorizontalAlignment	Sets the horizontal alignment of the table.
	NumberFormatLocal	Sets data display format of the table.
	RangeAddress	Gets the range address of the Table. For example:"A1:F5".
	ReadOnly	Sets a value that indicates whether the Table is read-only.
	RowHeight	Sets the height of all the rows in the Table, measured in points.
	VerticalAlignment	Sets the vertical alignment of the table.

Top

Remarks

Table class is an important Excel table class defined in Aceoffix.

In Excel worksheet, we can define any range of cells containing a contiguous block of cells as a Table object. Table class encapsulates a series of data operations implementing in the continuous range of cells based on data table. Table class simplifies the complex operations to the ranges of Excel cells. And developer can work in the range of Excel cells as simple as in data table. Therefore, development efficiency and code stability are improved.

You can use Table object not only to fill data into a specified range of cells, but also to draw a new table on a blank range.

You can only call the OpenTable(String) method and [M:Aceoffix.ExcelWriter.Sheet.OpenTableByDefinedName(System.String, System.Int, System.Int)] method to get the Table object.

Reference

Aceoffix.ExcelWriter Namespace