Click or drag to resize

XlsWorksheet 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.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public int InsertDataTable(
	DataTable dataTable,
	bool columnHeaders,
	int firstRow,
	int firstColumn,
	int maxRows,
	int maxColumns,
	bool transTypes
)

Parameters

dataTable
Type: System.Data DataTable
Datatable
columnHeaders
Type: System Boolean
Indicates whether to import field names.
firstRow
Type: System Int32
The row number of the first cell to import in.
firstColumn
Type: System Int32
The column number of the first cell to import in.
maxRows
Type: System Int32
Maximum number of rows to import
maxColumns
Type: System Int32
Maximum number of columns to import
transTypes
Type: System Boolean
Indicates if preserve types when insert data into worksheet

Return Value

Type: Int32

Implements

IWorksheet InsertDataTable(DataTable, Boolean, Int32, Int32, Int32, Int32, Boolean)
See Also