Click or drag to resize

IWorksheet InsertDataTable Method (DataTable, Boolean, Int32, Int32, Int32, Int32, Boolean)

Imports data from a DataTable into worksheet.
Examples
The following code illustrates how to Imports data from a DataTable into a worksheet with specified range along with preserve type:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create a DataTable</para><para>System.Data.DataTable table = new System.Data.DataTable();</para><para>table.Columns.Add("ID", typeof(int));
 table.Columns.Add("Item", typeof(string));
 table.Columns.Add("Name", typeof(string));</para><para>table.Rows.Add(1, "Soap", "David");
 table.Rows.Add(2, "Paste", "Sam");
 table.Rows.Add(3, "Cream", "Christoff");</para><para>//Insert the DataTable to worksheet</para><para>worksheet.InsertDataTable(table, true, 1 , 1 , 2 , 2 , true);</para><para>//Save to file</para><para>workbook.SaveToFile(InsertDataTable.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
int InsertDataTable(
	DataTable dataTable,
	bool isFieldNameShown,
	int firstRow,
	int firstColumn,
	int maxRows,
	int maxColumns,
	bool preserveTypes
)

Parameters

dataTable
Type: System.Data DataTable
DataTable with desired data.
isFieldNameShown
Type: System Boolean
True if column names must also be imported.
firstRow
Type: System Int32
Row of the first cell where DataTable should be imported.
firstColumn
Type: System Int32
Column of the first cell where DataTable should be imported.
maxRows
Type: System Int32
Maximum number of rows to import.
maxColumns
Type: System Int32
Maximum number of columns to import.
preserveTypes
Type: System Boolean
Indicates whether XlsIO should try to preserve types in DataTable, i.e. if it is set to False (default) and in DataTable we have in string column value that contains only numbers, it would be converted to number.

Return Value

Type: Int32
Number of imported rows.
See Also