Spread WinForms 15
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)

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

Reference

IExcelBiffWrite Interface
IExcelBiffWrite Members

 

 

Copyright © 2021 GrapeCity, Inc. All rights reserved.

Product Support Forum | Print this page