'Declaration
Public Class CSVImportOptions Inherits ImportOptions
'Usage
Dim instance As CSVImportOptions
public class CSVImportOptions : ImportOptions
'Declaration
Public Class CSVImportOptions Inherits ImportOptions
'Usage
Dim instance As CSVImportOptions
public class CSVImportOptions : ImportOptions
var workbook = Workbook.Create( "test.xlsx" ); var worksheet = workbook.Worksheets[ 0 ]; // Define a path to a csv document, the import options(which separator to use) and call the ImportData function. var stringSCVData = "Book1.csv"; var stringCSVImportOptions = new CSVImportOptions() { DestinationTopLeftAddress = "C5", Separator = "," }; worksheet.ImportData( stringSCVData, stringCSVImportOptions ); workbook.Save();
System.Object
Xceed.Workbooks.NET.ImportOptions
Xceed.Workbooks.NET.CSVImportOptions
Name | Description | |
---|---|---|
![]() | CSVImportOptions Constructor |
Name | Description | |
---|---|---|
![]() | 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) |
![]() | 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) |
![]() | Separator | Gets or sets the separator used to split the CSV data. The default value is ",". |
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