CSVImportOptions Class

Specifies the properties of the import options for a CSV document or stream when importing data in a Worksheet through the Worksheet.ImportData method.

Syntax

Visual Basic
C#

'Declaration

 

Public Class CSVImportOptions 

   Inherits ImportOptions

'Usage

 

Dim instance As CSVImportOptions

public class CSVImportOptions : ImportOptions

Remarks

This class derives from ImportOptions. It is useful when importing CSV data.

Example

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();

Inheritance Hierarchy

System.Object
Xceed.Workbooks.NET.ImportOptions
Xceed.Workbooks.NET.CSVImportOptions

Requirements

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

Reference

CSVImportOptions Members
Xceed.Workbooks.NET Namespace