alexa
menu

MAUI

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

    Show / Hide Table of Contents

    Class PivotViewDefinitionRecord

    This record contains top-level PivotTable information.

    Inheritance
    object
    BiffRecordRaw
    BiffRecordRawWithArray
    PivotViewDefinitionRecord
    Implements
    ICloneable
    IBiffStorage
    IDisposable
    Inherited Members
    BiffRecordRawWithArray.AutoExtractFields()
    BiffRecordRawWithArray.AutoGrowData
    BiffRecordRawWithArray.AutoInfillFromFields()
    BiffRecordRawWithArray.CheckOffsetAndLength(int, int)
    BiffRecordRawWithArray.ClearData()
    BiffRecordRawWithArray.CopyTo(BiffRecordRaw)
    BiffRecordRawWithArray.Data
    BiffRecordRawWithArray.Dispose()
    BiffRecordRawWithArray.EnlargeDataStorageIfNeeded(int, int)
    BiffRecordRawWithArray.FillStream(BinaryWriter, DataProvider, IEncryptor, int)
    BiffRecordRawWithArray.FillStream(BinaryWriter, IEncryptor, int)
    BiffRecordRawWithArray.GetAddr(int)
    BiffRecordRawWithArray.GetAddrAsRectangle(int)
    BiffRecordRawWithArray.GetBit(int, int)
    BiffRecordRawWithArray.GetByte(int)
    BiffRecordRawWithArray.GetBytes(int, int)
    BiffRecordRawWithArray.GetDouble(int)
    BiffRecordRawWithArray.GetFloat(int)
    BiffRecordRawWithArray.GetInt16(int)
    BiffRecordRawWithArray.GetInt32(int)
    BiffRecordRawWithArray.GetInt64(int)
    BiffRecordRawWithArray.GetStoreSize(ExcelVersion)
    BiffRecordRawWithArray.GetString(int, int)
    BiffRecordRawWithArray.GetString(int, int, out int)
    BiffRecordRawWithArray.GetString(int, int, out int, bool)
    BiffRecordRawWithArray.GetString16BitUpdateOffset(ref int)
    BiffRecordRawWithArray.GetString16BitUpdateOffset(ref int, out bool)
    BiffRecordRawWithArray.GetStringByteLen(int)
    BiffRecordRawWithArray.GetStringByteLen(int, out int)
    BiffRecordRawWithArray.GetStringUpdateOffset(ref int, int)
    BiffRecordRawWithArray.GetUInt16(int)
    BiffRecordRawWithArray.GetUInt32(int)
    BiffRecordRawWithArray.GetUInt64(int)
    BiffRecordRawWithArray.GetUnkTypeString(int, IList<int>, int, ref int, out int, out byte[], out byte[])
    BiffRecordRawWithArray.GetValueByAttributeType(BiffRecordPosAttribute)
    BiffRecordRawWithArray.IsAsciiString(string)
    BiffRecordRawWithArray.IsEqual(BiffRecordRaw)
    BiffRecordRawWithArray.m_data
    BiffRecordRawWithArray.OnDispose()
    BiffRecordRawWithArray.ParseStructure(DataProvider, int, int, ExcelVersion)
    BiffRecordRawWithArray.Reserve(int)
    BiffRecordRawWithArray.SetAddr(int, Rectangle)
    BiffRecordRawWithArray.SetAddr(int, TAddr)
    BiffRecordRawWithArray.SetBit(int, bool, int)
    BiffRecordRawWithArray.SetByte(int, byte)
    BiffRecordRawWithArray.SetByte(int, byte, int)
    BiffRecordRawWithArray.SetBytes(int, byte[])
    BiffRecordRawWithArray.SetBytes(int, byte[], int, int)
    BiffRecordRawWithArray.SetDouble(int, double)
    BiffRecordRawWithArray.SetFloat(int, float)
    BiffRecordRawWithArray.SetInt16(int, short)
    BiffRecordRawWithArray.SetInt32(int, int)
    BiffRecordRawWithArray.SetInt64(int, long)
    BiffRecordRawWithArray.SetString16BitLen(int, string)
    BiffRecordRawWithArray.SetString16BitLen(int, string, bool, bool)
    BiffRecordRawWithArray.SetString16BitUpdateOffset(ref int, string)
    BiffRecordRawWithArray.SetString16BitUpdateOffset(ref int, string, bool)
    BiffRecordRawWithArray.SetStringByteLen(int, string)
    BiffRecordRawWithArray.SetStringNoLen(int, string)
    BiffRecordRawWithArray.SetStringNoLen(int, string, bool, bool)
    BiffRecordRawWithArray.SetStringNoLenDetectEncoding(int, string)
    BiffRecordRawWithArray.SetStringNoLenUpdateOffset(ref int, string, bool)
    BiffRecordRawWithArray.SetUInt16(int, ushort)
    BiffRecordRawWithArray.SetUInt32(int, uint)
    BiffRecordRawWithArray.SetUInt64(int, ulong)
    BiffRecordRawWithArray.SetValueByAttributeType(BiffRecordPosAttribute, object)
    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.PivotViewDefinition)]
    [CLSCompliant(false)]
    public class PivotViewDefinitionRecord : BiffRecordRawWithArray, ICloneable, IBiffStorage, IDisposable

    Constructors

    PivotViewDefinitionRecord()

    Default constructor.

    Declaration
    public PivotViewDefinitionRecord()

    PivotViewDefinitionRecord(Stream, out int)

    Read / initialize constructor.

    Declaration
    public PivotViewDefinitionRecord(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.

    PivotViewDefinitionRecord(int)

    Reserved for record's internal data array.

    Declaration
    public PivotViewDefinitionRecord(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

    AutoFormatIndex

    Index to the PivotTable autoformat.

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

    CacheIndex

    Index to the cache.

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

    ColumnFieldsNumber

    Number of column fields.

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

    DataAxis

    Default axis for a data field.

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

    DataColumnsNumber

    Number of data columns.

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

    DataFieldName

    Name of the data field.

    Declaration
    public string DataFieldName { get; set; }
    Property Value
    Type
    string

    DataFieldNameLength

    Length of the data field name. Read-only.

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

    DataFieldsNumber

    Number of data fields.

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

    DataPos

    Default position for a data field.

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

    DataRowsNumber

    Number of data rows.

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

    FieldsNumber

    Number of fields.

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

    FirstColumn

    First column of the PivotTable.

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

    FirstDataColumn

    First column containing PivotTable data.

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

    FirstDataRow

    First row containing PivotTable data.

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

    FirstHeadRow

    First row containing PivotTable headings.

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

    FirstRow

    First row of the PivotTable.

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

    IsAlignAutoFormat

    Indicates whether the alignment autoformat is applied.

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

    IsAutoFormat

    Indicates whether the PivotTable has an autoformat applied.

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

    IsBorderAutoFormat

    Indicates whether the Border autoformat is applied.

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

    IsColumnGrand

    Indicates whether the PivotTable contains grand totals for columns.

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

    IsFontAutoFormat

    Indicates whether the font autoformat is applied.

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

    IsNumberAutoFormat

    Indicates whether the PivotTable has an autoformat applied.

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

    IsPatternAutoFormat

    Indicates whether the pattern autoformat is applied.

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

    IsRowGrand

    Indicates whether the PivotTable contains grand totals for rows.

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

    IsWHAutoFormat

    Indicates whether the width / height autoformat is applied.

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

    LastColumn

    Last column of the PivotTable.

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

    LastRow

    Last row of the PivotTable.

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

    Options

    Option flags. Read-only.

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

    PageFieldsNumber

    Number of page fields.

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

    Reserved

    Reserved. Must be zero. Read-only.

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

    RowFieldsNumber

    Number of row fields.

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

    TableName

    PivotTable name.

    Declaration
    public string TableName { get; set; }
    Property Value
    Type
    string

    TableNameLength

    Length of the PivotTable name. Read-only.

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

    Methods

    ParseStructure()

    Parse structure of record. Convert Data buffer to special values according to record specification.

    Declaration
    public override void ParseStructure()
    Overrides
    BiffRecordRawWithArray.ParseStructure()

    Implements

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