Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffRead Interface
Properties Methods

In This Topic
    IExcelBiffRead Interface Members
    In This Topic

    The following tables list the members exposed by IExcelBiffRead.

    Public Properties
     NameDescription
    PropertyExcelChartReaderGet ExcelChartReader  
    Top
    Public Methods
     NameDescription
    MethodExcelAddSheetBUNDLESHEET - Excel Biff Record  
    MethodExcelBofBeginning of file; notifies the implementation that the workbook load is beginning or we are loading a new sheet. This is needed to clear the shared formula list for each sheet.  
    MethodExcelGetCommentObjIdOBJ  
    MethodExcelGetFontInfoGets the font information for importing from Excel BIFF file. Called to determine if Spread Web or Spread Win build. Spread Web stores the default font name in the resources.  
    MethodExcelGetSharedFormulaCalled from BiffRead to query the Shared Formula list maintained in the implementation of this interface  
    MethodExcelSet19041904 - Excel Biff Record  
    MethodExcelSetArrayFormulaARRAY - Excel Biff Record  
    MethodExcelSetBottomMarginBOTTOMMARGIN - Excel Biff Record  
    MethodExcelSetCalcCountCALCCOUNT - Excel Biff Record  
    MethodExcelSetCalcModeCALCMODE - Excel Biff Record  
    MethodExcelSetCellFormatFORMAT - Sets the cell format. - Excel Biff Record  
    MethodExcelSetCellFormulaOverloaded. FORMULA - Excel Biff Record Sets the formula for the specified location and options.  
    MethodExcelSetCellNoteCELL NOTE - Excel Biff Record Sets the cell note for the specified location and options.  
    MethodExcelSetCellValueLABEL, LABELSST, NUMBER, RK - Excel Biff Records  
    MethodExcelSetColInfoCOLINFO - Excel Biff Record  
    MethodExcelSetColumnPageBreaksVERTICALPAGEBREAKS - Excel Biff Record  
    MethodExcelSetCommentObjIdOBJ  
    MethodExcelSetConditionalFormatCONDFMT, CF - Excel Biff Records  
    MethodExcelSetCustomNamesNAME - Excel Biff Record  
    MethodExcelSetDefaultRowHeightDEFAULTROWHEIGHT - Excel Biff Record  
    MethodExcelSetDefColWidthDEFCOLWIDTH - Excel Biff Record  
    MethodExcelSetDeltaDELTA - Excel Biff Record  
    MethodExcelSetDimensionsDIMENSIONS - Excel Biff Record  
    MethodExcelSetDisplayElementsWINDOW2 - Excel Biff Record (element display values)  
    MethodExcelSetDrawingObjetsVisibleif set hide all in Excel, hide all shapes and charts.  
    MethodExcelSetExternNameExcelSetExternName  
    MethodExcelSetExternSheetExcelSetExternSheet  
    MethodExcelSetExternSheet2Overloaded. ExcelSetExternSheet  
    MethodExcelSetFilePassExcelSetFilePass  
    MethodExcelSetFooterFOOTER - Excel Biff Record  
    MethodExcelSetHCenterExcelSetHCenter  
    MethodExcelSetHeaderHEADER - Excel Biff Record  
    MethodExcelSetIterationExcelSetIteration  
    MethodExcelSetLeftMarginExcelSetLeftMargin - Excel Biff Record  
    MethodExcelSetMergeCellsMERGECELLS - Excel Biff Record  
    MethodExcelSetPageSetupExcelSetPageSetup - Excel Biff Record  
    MethodExcelSetPanePANE - Excel Biff Record  
    MethodExcelSetPasswordPASSWORD - Excel Biff Record  
    MethodExcelSetPrintAreaPrint_Area - Excel Built-In Custom Name  
    MethodExcelSetPrintGridlinesExcelSetPrintGridlines  
    MethodExcelSetPrintHeadersExcelSetPrintHeaders  
    MethodExcelSetPrintTitlesPrint_Titles - Excel Built-In Custom Name  
    MethodExcelSetProtectPROTECT - Excel Biff Record  
    MethodExcelSetRefModeREFMODE - Excel Biff Record  
    MethodExcelSetRightMarginExcelSetRightMargin - Excel Biff Record  
    MethodExcelSetRowColGridColorWINDOW2 - Excel Biff Record (row and column headers, and grid color value)  
    MethodExcelSetRowColumnHeadersExcelSetRowColumnHeaders  
    MethodExcelSetRowInfoExcelSetRowInfo - Excel Biff Record  
    MethodExcelSetRowPageBreaksHORIZONTALPAGEBREAKS - Excel Biff Record  
    MethodExcelSetSaveExtLinksBOOKBOOL - Excel Biff Record  
    MethodExcelSetScrollWINDOW1 - Excel Biff Record (scrollbar-specific values)  
    MethodExcelSetSelectionExcelSetSelection - Excel Biff Record  
    MethodExcelSetShapeListSets the Excel shape list.  
    MethodExcelSetSharedFormulaSHRFMLA - Excel Biff Record  
    MethodExcelSetSheetTabColorSets the Sheet Tab Color  
    MethodExcelSetSupbookSUPBOOK - Excel Biff Record  
    MethodExcelSetSupbook2SUPBOOK - Excel Biff Record  
    MethodExcelSetTabsWINDOW1 - Excel Biff Record (tab-specific values)  
    MethodExcelSetTopLeftWINDOW2 - Excel Biff Record (toprow, left column values)  
    MethodExcelSetTopMarginExcelSetTopMargin - Excel Biff Record  
    MethodExcelSetValidationDataSets the validation data for a range of cells in the specified sheet.  
    MethodExcelSetVCenterExcelSetVCenter - Excel Biff Record  
    MethodExcelSetWindowWINDOW1 - Excel Biff Record (window-specific values)  
    MethodExcelSetXFExcelSetXF - Excel Biff  
    MethodExcelSetZoomSCL - Excel Biff Record (Zoom)  
    MethodFinishFinish - called after the Excel BIFF file has completed loading.  
    MethodSetDataSourceSet the sheet data model  
    Top
    See Also

    Reference

    IExcelBiffRead Interface
    FarPoint.Excel Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page