GrapeCity.Xaml.Excel
IExcelReader Interface Methods

GrapeCity.Excel Namespace : IExcelReader Interface

For a list of all members of this type, see IExcelReader members.

Public Methods
 NameDescription
 MethodAdd a new IExcelWorksheet instance to the underlying IExcelWorkbook model.  
 Method Beginning of file; notifies the implementer that the global workbook stream is loading or we are loading a new Worksheet.  
 Method It will be called after the Excel file has completed loading.  
 Method This method will be invoked when exception or abnormal condition happens  
 Method Set array formula to a range of cells  
 MethodAdd an IExcelAutoFilter instance to the specified sheet  
 Method Add all used builtIn names to workbook  
 MethodSet the CalculationProperty property for the entire workbook.  
 Method A all-in-one method which will set value, cell type, format index and formula for the specified cell.  
 Method Set formula for a specified cell.  
 Method Set hyperlink to a specified cell.  
 Method Sets cell note for the specified cell.  
 Method Set the format properties for a specified cell.  
 Method Set value to a specified cell  
 Method Set the custom palette used in the workbook  
 Method Set serials properties to specified columns.  
 MethodAdd a new ExcelConditionalFormat instance to the specified worksheet  
 Method Add all custom or function names to workbook  
 Method Set the default column width  
 Method Set 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  
 Method Set the minimum and maximum bounds of the sheet.  
 Method Set 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  
 Method Set the default cell format of the workbook  
 Method Add built-in or user defined style to the workbook  
 MethodSet the IExcelWorkbookPropery for the entire Workbook.  
 Method Add the external referenced workbook info to the workbook  
 Method Set the gridline color for the specified worksheet.  
 Method Set the merged cell information  
 Method Sets the named cell range  
 Method Set the summary row/column directions  
 Method Set the number and position of unfrozen panes in a window  
 Method Set 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.  
 Method Set the print title of the specified zero-based sheet  
 Method Set the protection state for a sheet or workbook  
 Method Set the size of row and column gutters which is measured in screen units.  
 Method Set the row information at the specified index.  
 Method Set the horizontal and vertical scroll bar policies for workbook  
 Method Set the cell selections for the specified worksheet  
 Method Set the tab information of the workbook  
 Method Set the theme used in the workbook  
 Method Set the first visible row and column information in the window  
 MethodAdd an IExcelDataValidation instance for a range of cells  
 Method Set the location of the window, whether it's hidden or currently displayed as an icon  
 Method Set the zoom magnification for a specified sheet  
Top
See Also

Reference

IExcelReader Interface
GrapeCity.Excel Namespace