alexa
menu

MAUI

  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Search Results for

    Show / Hide Table of Contents

    Class ExternalSourceInfoRecord

    This record stores information about the SQL query string that retrieves external data for a PivotTable. The record is followed by SXSTRING records that contain the SQL strings and then by a SXSTRING record that contains the SQL server connection string.

    Inheritance
    object
    BiffRecordRaw
    ExternalSourceInfoRecord
    Implements
    ICloneable
    IBiffStorage
    Inherited Members
    object.Equals(object)
    object.Equals(object, object)
    object.GetHashCode()
    object.GetType()
    object.MemberwiseClone()
    object.ReferenceEquals(object, object)
    object.ToString()
    Namespace: Syncfusion.XlsIO.Parser.Biff_Records.PivotTable
    Assembly: Syncfusion.XlsIO.NET.dll
    Syntax
    [Biff(TBIFFRecord.DbOrParamQry)]
    [CLSCompliant(false)]
    public class ExternalSourceInfoRecord : BiffRecordRaw, ICloneable, IBiffStorage

    Constructors

    ExternalSourceInfoRecord()

    Default constructor.

    Declaration
    public ExternalSourceInfoRecord()

    ExternalSourceInfoRecord(Stream, out int)

    Read / initialize constructor.

    Declaration
    public ExternalSourceInfoRecord(Stream stream, out int itemSize)
    Parameters
    Type Name Description
    Stream stream

    Stream from which record data should be read.

    int itemSize

    Size of read item.

    Exceptions
    Type Condition
    ArgumentNullException

    When stream is not specified.

    ApplicationException

    When stream does not support read or seek operations.

    ExternalSourceInfoRecord(int)

    Reserved for record's internal data array.

    Declaration
    public ExternalSourceInfoRecord(int iReserve)
    Parameters
    Type Name Description
    int iReserve

    Amount of bytes for the data array.

    Exceptions
    Type Condition
    ArgumentOutOfRangeException

    If amount of bytes requested is less than zero.

    Properties

    DataSourceType

    1 - ODBC data source, 2 - DAO recordset (no actual information about the recordset is saved), 3 - reserved, 4 - Web (WWW) query.

    Declaration
    public ushort DataSourceType { get; set; }
    Property Value
    Type
    ushort

    IsOdbcConnection

    True for ODBC connection.

    Declaration
    public bool IsOdbcConnection { get; set; }
    Property Value
    Type
    bool

    IsSavePassword

    Indicates whether save password option is on.

    Declaration
    public bool IsSavePassword { get; set; }
    Property Value
    Type
    bool

    IsSql

    True for SQL statement or URL.

    Declaration
    public bool IsSql { get; set; }
    Property Value
    Type
    bool

    IsSqlSav

    True for server-based page fields.

    Declaration
    public bool IsSqlSav { get; set; }
    Property Value
    Type
    bool

    IsTablesOnlyHtml

    Indicates whether save tables in HTML only option is on.

    Declaration
    public bool IsTablesOnlyHtml { get; set; }
    Property Value
    Type
    bool

    IsWeb

    True for Web (WWW) query.

    Declaration
    public bool IsWeb { get; set; }
    Property Value
    Type
    bool

    OdbcConnectionCount

    Number of strings for ODBC connection string.

    Declaration
    public ushort OdbcConnectionCount { get; set; }
    Property Value
    Type
    ushort

    Options

    Options flags. Read-only.

    Declaration
    public ushort Options { get; }
    Property Value
    Type
    ushort

    ParamsCount

    Number of parameter strings.

    Declaration
    public ushort ParamsCount { get; set; }
    Property Value
    Type
    ushort

    QueryCount

    Number of strings for SQL statement or URL.

    Declaration
    public ushort QueryCount { get; set; }
    Property Value
    Type
    ushort

    SQLSavCount

    Number of strings for SQL statement for server-based page fields.

    Declaration
    public ushort SQLSavCount { get; set; }
    Property Value
    Type
    ushort

    WebPostCount

    Number of strings for post method of Web query.

    Declaration
    public ushort WebPostCount { get; set; }
    Property Value
    Type
    ushort

    Methods

    GetStoreSize(ExcelVersion)

    Evaluates size of the required storage space.

    Declaration
    public override int GetStoreSize(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version
    Returns
    Type Description
    int

    Size of the required storage space.

    Overrides
    BiffRecordRaw.GetStoreSize(ExcelVersion)

    ParseStructure(DataProvider, int, int, ExcelVersion)

    Parse structure of record. Converts data buffer to special values according to record specification.

    Declaration
    public override void ParseStructure(DataProvider provider, int iOffset, int iLength, ExcelVersion version)
    Parameters
    Type Name Description
    DataProvider provider

    Object that provides access to the data.

    int iOffset

    Offset to the record's data.

    int iLength

    Length of the record's data.

    ExcelVersion version

    Excel version used for infill.

    Overrides
    BiffRecordRaw.ParseStructure(DataProvider, int, int, ExcelVersion)

    Implements

    ICloneable
    IBiffStorage
    In this article
    Back to top Generated by DocFX
    Copyright © 2001 - 2026 Syncfusion Inc. All Rights Reserved