Spread WPF Documentation
GrapeCity.Excel Namespace / IExcelReader Interface
Methods

In This Topic
    IExcelReader Interface Members
    In This Topic

    The following tables list the members exposed by IExcelReader.

    Public Methods
     NameDescription
     MethodAdd a new IExcelWorksheet instance to the underlying IExcelWorkbook model.  
     MethodBeginning of file; notifies the implementer that the global workbook stream is loading or we are loading a new Worksheet.  
     MethodIt will be called after the Excel file has completed loading.  
     MethodThis method will be invoked when exception or abnormal condition happens  
     MethodSet array formula to a range of cells  
     MethodAdd an IExcelAutoFilter instance to the specified sheet  
     MethodAdd all used builtIn names to workbook  
     MethodSet the CalculationProperty property for the entire workbook.  
     MethodA all-in-one method which will set value, cell type, format index and formula for the specified cell.  
     MethodSet formula for a specified cell.  
     MethodSet hyperlink to a specified cell.  
     MethodSets cell note for the specified cell.  
     MethodSet the format properties for a specified cell.  
     MethodSet value to a specified cell  
     MethodSet the custom palette used in the workbook  
     MethodSet serials properties to specified columns.  
     MethodAdd a new ExcelConditionalFormat instance to the specified worksheet  
     MethodAdd all custom or function names to workbook  
     MethodSet the default column width  
     MethodSet the default row height.  
     MethodAdd IDifferentialFormatting collection to the workbook, which used to represent formatting properties that are used in various features to modify cell formatting  
     MethodSet the minimum and maximum bounds of the sheet.  
     MethodSet whether the specified sheet should show formula, show zeros, show gridline, show row column header, and whether its column is right to left.  
     MethodAdd an IExtendedFormat instance to workbook  
     MethodSet the default cell format of the workbook  
     MethodAdd built-in or user defined style to the workbook  
     MethodSet the IExcelWorkbookPropery for the entire Workbook.  
     MethodAdd the external referenced workbook info to the workbook  
     MethodSet the gridline color for the specified worksheet.  
     MethodSet the merged cell information  
     MethodSets the named cell range  
     MethodSet the summary row/column directions  
     MethodSet the number and position of unfrozen panes in a window  
     MethodSet the print area of the specified zero-based sheet  
     Method  
     MethodSet the print page margins for specified IExcelWorkbook instance.  
     MethodSet the print page margins for specified IExcelWorkbook instance.  
     MethodSet the print page margins for specified IExcelWorkbook instance.  
     MethodSet the print title of the specified zero-based sheet  
     MethodSet the protection state for a sheet or workbook  
     MethodSet the size of row and column gutters which is measured in screen units.  
     MethodSet the row information at the specified index.  
     MethodSet the horizontal and vertical scroll bar policies for workbook  
     MethodSet the cell selections for the specified worksheet  
     MethodSet the tab information of the workbook  
     MethodSet the theme used in the workbook  
     MethodSet the first visible row and column information in the window  
     MethodAdd an IExcelDataValidation instance for a range of cells  
     MethodSet the location of the window, whether it's hidden or currently displayed as an icon  
     MethodSet the zoom magnification for a specified sheet  
    Top
    See Also