The following tables list the members exposed by IExcelReader.
Public Methods
| Name | Description | |
|---|---|---|
 | AddSheet | Add a new IExcelWorksheet instance to the underlying IExcelWorkbook model. |
| Bof | Beginning of file; notifies the implementer that the global workbook stream is loading or we are loading a new Worksheet. |
| Finish | It will be called after the Excel file has completed loading. |
| OnExcelLoadError | This method will be invoked when exception or abnormal condition happens |
| SetArrayFormula | Set array formula to a range of cells |
| SetAutoFilter | Add an IExcelAutoFilter instance to the specified sheet |
| SetBuiltInNameList | Add all used builtIn names to workbook |
| SetCalculationProperty | Set the CalculationProperty property for the entire workbook. |
| SetCell | A all-in-one method which will set value, cell type, format index and formula for the specified cell. |
| SetCellFormula | Set formula for a specified cell. |
| SetCellHyperLink | Set hyperlink to a specified cell. |
| SetCellNote | Sets cell note for the specified cell. |
| SetCellStyle | Set the format properties for a specified cell. |
| SetCellValue | Set value to a specified cell |
| SetColorPalette | Set the custom palette used in the workbook |
| SetColumnInfo | Set serials properties to specified columns. |
| SetConditionalFormatting | Add a new ExcelConditionalFormat instance to the specified worksheet |
| SetCustomOrFunctionNameList | Add all custom or function names to workbook |
| SetDefaultColumnWidth | Set the default column width |
| SetDefaultRowHeight | Set the default row height. |
| SetDifferentialFormattingRecord | Add IDifferentialFormatting collection to the workbook, which used to represent formatting properties that are used in various features to modify cell formatting |
| SetDimensions | Set the minimum and maximum bounds of the sheet. |
| SetDisplayElements | Set whether the specified sheet should show formula, show zeros, show gridline, show row column header, and whether its column is right to left. |
| SetExcelCellFormat | Add an IExtendedFormat instance to workbook |
| SetExcelDefaultCellFormat | Set the default cell format of the workbook |
| SetExcelStyle | Add built-in or user defined style to the workbook |
| SetExcelWorkbookProperty | Set the IExcelWorkbookPropery for the entire Workbook. |
| SetExternalReferencedWorkbookInfo | Add the external referenced workbook info to the workbook |
| SetGridlineColor | Set the gridline color for the specified worksheet. |
| SetMergeCells | Set the merged cell information |
| SetNamedCellRange | Sets the named cell range |
| SetOutlineDirection | Set the summary row/column directions |
| SetPane | Set the number and position of unfrozen panes in a window |
| SetPrintArea | Set the print area of the specified zero-based sheet |
| SetPrintHFImage | |
| SetPrintOption | Set the print page margins for specified IExcelWorkbook instance. |
| SetPrintPageMargin | Set the print page margins for specified IExcelWorkbook instance. |
| SetPrintPageSetting | Set the print page margins for specified IExcelWorkbook instance. |
| SetPrintTitles | Set the print title of the specified zero-based sheet |
| SetProtect | Set the protection state for a sheet or workbook |
| SetRowColumnGutters | Set the size of row and column gutters which is measured in screen units. |
| SetRowInfo | Set the row information at the specified index. |
| SetScroll | Set the horizontal and vertical scroll bar policies for workbook |
| SetSelection | Set the cell selections for the specified worksheet |
| SetTabs | Set the tab information of the workbook |
| SetTheme | Set the theme used in the workbook |
| SetTopLeft | Set the first visible row and column information in the window |
| SetValidationData | Add an IExcelDataValidation instance for a range of cells |
| SetWindow | Set the location of the window, whether it's hidden or currently displayed as an icon |
| SetZoom | Set the zoom magnification for a specified sheet |
See Also