Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ImportOptions Class
Example


In This Topic
    ImportOptions Class
    In This Topic
    Specifies the properties of the import options used when importing data in a Worksheet through the Worksheet.ImportData method.
    Syntax
    'Declaration
 

    Public Class ImportOptions 
    'Usage
 

    Dim instance As ImportOptions
    public class ImportOptions
    Remarks
    This is the base class for DataTableImportOptions, UserObjectImportOptions and CSVImportOptions.
    Example
    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();
    Inheritance Hierarchy

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

    Public Constructors
     NameDescription
    Public ConstructorImportOptions Constructor  
    Top
    Public Properties
     NameDescription
    Public PropertyDestinationColumnIdGets or sets the Id of the Column in which the first data item will be imported.  
    Public PropertyDestinationRowIdGets or sets the Id of the Row in which the first data item will be imported.    
    Public PropertyDestinationTopLeftAddressGets or sets the address of the Cell in which the first data item will be imported.  
    Public PropertyIsLinearDataVerticalGets or sets if the imported linear data (like a List<string>, Array<int>, MyProduct[], ...) will be displayed vertically in the Worksheet.  
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    ImportOptions Members
    Xceed.Workbooks.NET Namespace

    Send Feedback