Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffWrite Interface / ExcelGetDisplayElements Method
Sheet index
Whether to display the formulas
Whether to display the zeros
Whether to display the grid
Whether to display the headers
Whether to display columns right to left


In This Topic
    ExcelGetDisplayElements Method
    In This Topic
    Gets the display elements for exporting to Excel BIFF file.
    Syntax
    'Declaration
     
    
    Function ExcelGetDisplayElements( _
       ByVal sheet As Short, _
       ByRef dispFormula As Boolean, _
       ByRef dispZeros As Boolean, _
       ByRef dispGrid As Boolean, _
       ByRef dispRowColHdr As Boolean, _
       ByRef rightToLeftColumns As Boolean _
    ) As Boolean
    'Usage
     
    
    Dim instance As IExcelBiffWrite
    Dim sheet As Short
    Dim dispFormula As Boolean
    Dim dispZeros As Boolean
    Dim dispGrid As Boolean
    Dim dispRowColHdr As Boolean
    Dim rightToLeftColumns As Boolean
    Dim value As Boolean
     
    value = instance.ExcelGetDisplayElements(sheet, dispFormula, dispZeros, dispGrid, dispRowColHdr, rightToLeftColumns)
    bool ExcelGetDisplayElements( 
       short sheet,
       ref bool dispFormula,
       ref bool dispZeros,
       ref bool dispGrid,
       ref bool dispRowColHdr,
       ref bool rightToLeftColumns
    )

    Parameters

    sheet
    Sheet index
    dispFormula
    Whether to display the formulas
    dispZeros
    Whether to display the zeros
    dispGrid
    Whether to display the grid
    dispRowColHdr
    Whether to display the headers
    rightToLeftColumns
    Whether to display columns right to left
    See Also