'Declaration
Public Class ImportOptions
'Usage
Dim instance As ImportOptions
public class ImportOptions
'Declaration
Public Class ImportOptions
'Usage
Dim instance As ImportOptions
public class ImportOptions
var workbook = Workbook.Create( "test.xlsx" ); var worksheet = workbook.Worksheets[ 0 ]; // Define a list of strings, the import options(vertical by default) and call the ImportData function. var stringData = new List<string>() { "First", "Second", "Third", "Fourth" }; var stringImportOptions = new ImportOptions() { DestinationTopLeftAddress = "B5" }; worksheet.ImportData( stringData, stringImportOptions ); workbook.Save();
System.Object
Xceed.Workbooks.NET.ImportOptions
Xceed.Workbooks.NET.CSVImportOptions
Xceed.Workbooks.NET.DataTableImportOptions
Xceed.Workbooks.NET.UserObjectImportOptions
Name | Description | |
---|---|---|
![]() | ImportOptions Constructor |
Name | Description | |
---|---|---|
![]() | DestinationColumnId | Gets or sets the Id of the Column in which the first data item will be imported. |
![]() | DestinationRowId | Gets or sets the Id of the Row in which the first data item will be imported. |
![]() | DestinationTopLeftAddress | Gets or sets the address of the Cell in which the first data item will be imported. |
![]() | IsLinearDataVertical | Gets or sets if the imported linear data (like a List<string>, Array<int>, MyProduct[], ...) will be displayed vertically in the Worksheet. |
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