GemBox.Spreadsheet
  • Overview
  • Examples
  • Free version
  • Support
  • Pricelist

    Show / Hide Table of Contents

    LoadOptions Class

    Namespace:
    GemBox.Spreadsheet
    Assembly:
    GemBox.Spreadsheet.dll

    Represents a base class for loading options of various file formats.

    • C#
    • VB.NET
    public abstract class LoadOptions
    Public MustInherit Class LoadOptions
    Inheritance:
    System.Object
    LoadOptions
    Derived
    CsvLoadOptions
    FixedWidthLoadOptions
    HtmlLoadOptions
    OdsLoadOptions
    XlsbLoadOptions
    XlsLoadOptions
    XlsxLoadOptions
    XmlLoadOptions
    Remarks

    Following classes inherit from this base class:

    • XlsxLoadOptions
    • XlsbLoadOptions
    • XlsLoadOptions
    • OdsLoadOptions
    • CsvLoadOptions
    • FixedWidthLoadOptions
    • HtmlLoadOptions
    • XmlLoadOptions

    Properties

    CsvDefault

    Gets the default options for loading from Character Separated Values file format.

    • C#
    • VB.NET
    public static CsvLoadOptions CsvDefault { get; }
    Public Shared ReadOnly Property CsvDefault As CsvLoadOptions
    Property Value
    CsvLoadOptions
    Remarks

    MS Excel uses ';' as default if current culture uses ',' for decimal separator. GemBox.Spreadsheet always uses ','.

    HtmlDefault

    Gets the default options for loading from HyperText Markup Language File (HTML) format.

    • C#
    • VB.NET
    public static HtmlLoadOptions HtmlDefault { get; }
    Public Shared ReadOnly Property HtmlDefault As HtmlLoadOptions
    Property Value
    HtmlLoadOptions

    OdsDefault

    Gets the default options for loading from OpenDocument Spreadsheet file format.

    • C#
    • VB.NET
    public static OdsLoadOptions OdsDefault { get; }
    Public Shared ReadOnly Property OdsDefault As OdsLoadOptions
    Property Value
    OdsLoadOptions

    TxtDefault

    Gets the default options for loading from Tab delimited file format.

    • C#
    • VB.NET
    public static CsvLoadOptions TxtDefault { get; }
    Public Shared ReadOnly Property TxtDefault As CsvLoadOptions
    Property Value
    CsvLoadOptions

    XlsbDefault

    Gets the default options for loading from XLSX file format (Microsoft Excel Binary File Format).

    • C#
    • VB.NET
    public static XlsbLoadOptions XlsbDefault { get; }
    Public Shared ReadOnly Property XlsbDefault As XlsbLoadOptions
    Property Value
    XlsbLoadOptions

    XlsDefault

    Gets the default options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .

    • C#
    • VB.NET
    public static XlsLoadOptions XlsDefault { get; }
    Public Shared ReadOnly Property XlsDefault As XlsLoadOptions
    Property Value
    XlsLoadOptions

    XlsxDefault

    Gets the default options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later).

    • C#
    • VB.NET
    public static XlsxLoadOptions XlsxDefault { get; }
    Public Shared ReadOnly Property XlsxDefault As XlsxLoadOptions
    Property Value
    XlsxLoadOptions

    XmlDefault

    Gets the default options for loading from XML file format (XML Spreadsheet 2003).

    • C#
    • VB.NET
    public static XmlLoadOptions XmlDefault { get; }
    Public Shared ReadOnly Property XmlDefault As XmlLoadOptions
    Property Value
    XmlLoadOptions

    Examples

    Convert Excel files to PDF in C# and VB.NET
    Open and read Excel file in C# and VB.NET

    See Also

    Load(String)
    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.