'Declaration
Public Class DataTableImportOptions Inherits ImportOptions
'Usage
Dim instance As DataTableImportOptions
public class DataTableImportOptions : ImportOptions
'Declaration
Public Class DataTableImportOptions Inherits ImportOptions
'Usage
Dim instance As DataTableImportOptions
public class DataTableImportOptions : ImportOptions
var workbook = Workbook.Create("test.xlsx" ); var worksheet = workbook.Worksheets[ 0 ]; // Define a dataTable, the import options(show specific ColumnNames) and call the ImportData function. var dataTable = new DataTable( "Employees" ); dataTable.Columns.Add( "Name", typeof( string ) ); dataTable.Columns.Add( "Position", typeof( string ) ); dataTable.Columns.Add( "Experience", typeof( double ) ); dataTable.Columns.Add( "Salary", typeof( int ) ); dataTable.Rows.Add( "Jenny Melchuck", "Project Manager", 11.5d, 77000 ); dataTable.Rows.Add( "Cindy Gartner", "Medical Assistant", 1.3d, 56000 ); dataTable.Rows.Add( "Carl Jones", "Web Designer", 4d, 66000 ); dataTable.Rows.Add( "Anna Karlweiss", "Account Executive", 7.8d, 51000 ); dataTable.Rows.Add( "Julia Robertson", "Marketing Coordinator", 17.6d, 65000 ); var dataTableImportOptions = new DataTableImportOptions() { DestinationTopLeftAddress = "B5", ColumnNames = new string[] { "Name", "Experience", "Position" }, IsColumnNamesShown = true }; worksheet.ImportData( dataTable, dataTableImportOptions ); workbook.Save();
System.Object
Xceed.Workbooks.NET.ImportOptions
Xceed.Workbooks.NET.DataTableImportOptions
Name | Description | |
---|---|---|
![]() | DataTableImportOptions Constructor |
Name | Description | |
---|---|---|
![]() | ColumnNames | Gets or sets the names of the data table’s columns. |
![]() | DestinationColumnId | Gets or sets the Id of the Column in which the first data item will be imported. (Inherited from Xceed.Workbooks.NET.ImportOptions) |
![]() | DestinationRowId | Gets or sets the Id of the Row in which the first data item will be imported. (Inherited from Xceed.Workbooks.NET.ImportOptions) |
![]() | DestinationTopLeftAddress | Gets or sets the address of the Cell in which the first data item will be imported. (Inherited from Xceed.Workbooks.NET.ImportOptions) |
![]() | IsColumnNamesShown | Gets or sets if the data table’s ColumnNames will be shown or not. |
![]() | IsLinearDataVertical | Gets or sets if the imported linear data (like a List<string>, Array<int>, MyProduct[], ...) will be displayed vertically in the Worksheet. (Inherited from Xceed.Workbooks.NET.ImportOptions) |
Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2