Click or drag to resize

Worksheet ExportDataTable Method (Int32, Int32, Int32, Int32, ExportTableOptions)

Exports a portion of a DataTable starting from a specified cell and spanning a specified number of rows and columns.

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public DataTable ExportDataTable(
	int firstRow,
	int firstColumn,
	int maxRows,
	int maxColumns,
	ExportTableOptions options
)

Parameters

firstRow
Type: System Int32
The zero-based index of the first row to export.
firstColumn
Type: System Int32
The zero-based index of the first column to export.
maxRows
Type: System Int32
The maximum number of rows to export.
maxColumns
Type: System Int32
The maximum number of columns to export.
options
Type: Spire.Xls ExportTableOptions
The options for exporting the DataTable.

Return Value

Type: DataTable
A DataTable containing the exported portion of the original DataTable.
See Also