CellsImportDataTable Method (DataTable, Boolean, Int32, Int32, Boolean, Boolean)

Note: This API is now obsolete.

Imports a DataTable object into a worksheet.

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: 21.5.0.0 (21.5)
Syntax
[ObsoleteAttribute("Use Cells.ImportData(DataTable,int,int,ImportTableOptions) method, instead.")]
public int ImportDataTable(
	DataTable dataTable,
	bool isFieldNameShown,
	int firstRow,
	int firstColumn,
	bool insertRows,
	bool convertStringToNumber
)

Parameters

dataTable
Type: System.DataDataTable
The DataTable object to be imported.
isFieldNameShown
Type: SystemBoolean
Indicates whether the field name of the datatable will be imported to the first row. Default is true.
firstRow
Type: SystemInt32
The row number of the first cell to import.
firstColumn
Type: SystemInt32
The column number of the first cell to import.
insertRows
Type: SystemBoolean
Indicates whether extra rows are added to fit data.
convertStringToNumber
Type: SystemBoolean
Indicates if this method will try to convert string to number.

Return Value

Type: Int32
Total number of rows imported
Remarks
NOTE: This member is now obsolete. Instead, please use Cells.ImportData(DataTable,int,int,ImportTableOptions) method, instead. This property will be removed 12 months later since December 2018. Aspose apologizes for any inconvenience you may have experienced.
See Also