| Name | Description | |
|---|---|---|
 | ExcelChartReader | Get ExcelChartReader (Inherited from FarPoint.Excel.IExcelBiffRead) |
IExcelRead2 Interface Members
In This Topic
The following tables list the members exposed by IExcelRead2.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | ExcelAddSheet | BUNDLESHEET - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelBof | Beginning 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. (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelGetAutoFilter | Gets the Excel XML auto filter. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetCellFormulaString | Gets the Excel XML forumla string. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetColumnHeaderRowCount | Gets the Excel XML column header row count. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetCommentObjId | OBJ (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelGetConditionalFormatsXML | Get the Excel XML conditional format. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetCustomNames | Gets the Excel XML custom names. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetDefaultRowHeight | Gets the Excel XML default row height. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetDefColWidth | Gets the Excel XML default column width. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetDefColWidthXML | Gets the Excel XML column width. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetFontInfo | Gets 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. (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelGetOffset | Offset Value for Note Anchor (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetPageSetup | Gets the Excel XML page setup. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetRightToLeft | Get the right to left of Spread. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetRowHeaderColumnCount | Gets the Excel XML row header column count. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetShapes | Sets the Excel xml shapes. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelGetSharedFormula | Called from BiffRead to query the Shared Formula list maintained in the implementation of this interface (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSet1904 | 1904 - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetArrayFormula | ARRAY - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetAutoFilter | Sets the Excel XML auto filter. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetBottomMargin | BOTTOMMARGIN - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetCalcCount | CALCCOUNT - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetCalcMode | CALCMODE - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetCellFormat | Sets the Excel XML cell format. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetCellFormula | Sets the Excel XML cell formula. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetCellNote | CELL NOTE - Excel Biff Record Sets the cell note for the specified location and options. (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetCellValue | LABEL, LABELSST, NUMBER, RK - Excel Biff Records (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetColInfo | Sets the Excel XML column information. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetColumnPageBreaks | VERTICALPAGEBREAKS - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetCommentObjId | OBJ (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetConditionalFormat | Sets the Excel XML conditional format. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetCustomNames | Sets the Excel XML custom names. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetDefaultRowHeight | Sets the Excel XML default row height. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetDefColWidth | Sets the Excel XML default column width. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetDelta | DELTA - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetDimensions | DIMENSIONS - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetDisplayElements | WINDOW2 - Excel Biff Record (element display values) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetDrawingObjetsVisible | if set hide all in Excel, hide all shapes and charts. (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetExternName | ExcelSetExternName (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetExternSheet | ExcelSetExternSheet (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetExternSheet2 | ExcelSetExternSheet (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetFilePass | ExcelSetFilePass (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetFooter | FOOTER - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetHCenter | ExcelSetHCenter (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetHeader | HEADER - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetIteration | ExcelSetIteration (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetLeftMargin | ExcelSetLeftMargin - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetMergeCells | MERGECELLS - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetPageSetup | Sets the Excel XML Page setup. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetPane | PANE - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetPassword | PASSWORD - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetPrintArea | Print_Area - Excel Built-In Custom Name (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetPrintGridlines | ExcelSetPrintGridlines (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetPrintHeaders | ExcelSetPrintHeaders (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetPrintTitles | Print_Titles - Excel Built-In Custom Name (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetProtect | PROTECT - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetRefMode | REFMODE - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetRightMargin | ExcelSetRightMargin - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetRowColGridColor | WINDOW2 - Excel Biff Record (row and column headers, and grid color value) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetRowColumnHeaders | ExcelSetRowColumnHeaders (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetRowInfo | Sets the Excel XML row information. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetRowPageBreaks | HORIZONTALPAGEBREAKS - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetSaveExtLinks | BOOKBOOL - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetScroll | WINDOW1 - Excel Biff Record (scrollbar-specific values) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetSelection | ExcelSetSelection - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetShapeList | Sets the Excel shape list. (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetShapes | Gets the Excel xml shapes. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetSharedFormula | SHRFMLA - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetSheetTabColor | Sets the Sheet Tab Color (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetStyle | Sets the Excel XML style. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetSupbook | SUPBOOK - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetSupbook2 | SUPBOOK - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetTabs | WINDOW1 - Excel Biff Record (tab-specific values) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetTopLeft | WINDOW2 - Excel Biff Record (toprow, left column values) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetTopMargin | ExcelSetTopMargin - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetValidationData | Sets the Excel XML validation data. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetVCenter | ExcelSetVCenter - Excel Biff Record (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetVisible | Sets the Excel XML sheet visibility. (Inherited from FarPoint.Excel.IExcelXml) |
| ExcelSetWindow | WINDOW1 - Excel Biff Record (window-specific values) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetXF | ExcelSetXF - Excel Biff (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelSetZoom | SCL - Excel Biff Record (Zoom) (Inherited from FarPoint.Excel.IExcelBiffRead) |
| ExcelXML | Handles Excel XML. (Inherited from FarPoint.Excel.IExcelXml) |
| Finish | Finish - called after the Excel BIFF file has completed loading. (Inherited from FarPoint.Excel.IExcelBiffRead) |
| GetSheetViewColumnCount | Gets the column count of an specified sheet. |
| ReformatSpanBorders | Reformats the span borders. |
| SetDataSource | Set the sheet data model (Inherited from FarPoint.Excel.IExcelBiffRead) |
| SetSheetViewColumnCount | Set the column count of an specified sheet. |
See Also