GrapeCity.Excel Namespace : IExcelReader Interface |
The following tables list the members exposed by IExcelReader.
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 |