Spread Silverlight Documentation
IExcelReader Interface Members
Methods 

The following tables list the members exposed by IExcelReader.

Public Methods
 NameDescription
 MethodAddSheetAdd a new IExcelWorksheet instance to the underlying IExcelWorkbook model.  
 MethodBofBeginning of file; notifies the implementer that the global workbook stream is loading or we are loading a new Worksheet.  
 MethodFinishIt will be called after the Excel file has completed loading.  
 MethodOnExcelLoadErrorThis method will be invoked when exception or abnormal condition happens  
 MethodSetArrayFormulaSet array formula to a range of cells  
 MethodSetAutoFilterAdd an IExcelAutoFilter instance to the specified sheet  
 MethodSetBuiltInNameListAdd all used builtIn names to workbook  
 MethodSetCalculationPropertySet the CalculationProperty property for the entire workbook.  
 MethodSetCellA all-in-one method which will set value, cell type, format index and formula for the specified cell.  
 MethodSetCellFormulaSet formula for a specified cell.  
 MethodSetCellHyperLinkSet hyperlink to a specified cell.  
 MethodSetCellNoteSets cell note for the specified cell.  
 MethodSetCellStyleSet the format properties for a specified cell.  
 MethodSetCellValueSet value to a specified cell  
 MethodSetColorPaletteSet the custom palette used in the workbook  
 MethodSetColumnInfoSet serials properties to specified columns.  
 MethodSetConditionalFormattingAdd a new ExcelConditionalFormat instance to the specified worksheet  
 MethodSetCustomOrFunctionNameListAdd all custom or function names to workbook  
 MethodSetDefaultColumnWidthSet the default column width  
 MethodSetDefaultRowHeightSet the default row height.  
 MethodSetDifferentialFormattingRecordAdd IDifferentialFormatting collection to the workbook, which used to represent formatting properties that are used in various features to modify cell formatting  
 MethodSetDimensionsSet the minimum and maximum bounds of the sheet.  
 MethodSetDisplayElementsSet whether the specified sheet should show formula, show zeros, show gridline, show row column header, and whether its column is right to left.  
 MethodSetExcelCellFormatAdd an IExtendedFormat instance to workbook  
 MethodSetExcelDefaultCellFormatSet the default cell format of the workbook  
 MethodSetExcelStyleAdd built-in or user defined style to the workbook  
 MethodSetExcelWorkbookPropertySet the IExcelWorkbookPropery for the entire Workbook.  
 MethodSetExternalReferencedWorkbookInfoAdd the external referenced workbook info to the workbook  
 MethodSetGridlineColorSet the gridline color for the specified worksheet.  
 MethodSetMergeCellsSet the merged cell information  
 MethodSetNamedCellRangeSets the named cell range  
 MethodSetOutlineDirectionSet the summary row/column directions  
 MethodSetPaneSet the number and position of unfrozen panes in a window  
 MethodSetPrintAreaSet the print area of the specified zero-based sheet  
 MethodSetPrintHFImage  
 MethodSetPrintOptionSet the print page margins for specified IExcelWorkbook instance.  
 MethodSetPrintPageMarginSet the print page margins for specified IExcelWorkbook instance.  
 MethodSetPrintPageSettingSet the print page margins for specified IExcelWorkbook instance.  
 MethodSetPrintTitlesSet the print title of the specified zero-based sheet  
 MethodSetProtectSet the protection state for a sheet or workbook  
 MethodSetRowColumnGuttersSet the size of row and column gutters which is measured in screen units.  
 MethodSetRowInfoSet the row information at the specified index.  
 MethodSetScrollSet the horizontal and vertical scroll bar policies for workbook  
 MethodSetSelectionSet the cell selections for the specified worksheet  
 MethodSetTabsSet the tab information of the workbook  
 MethodSetThemeSet the theme used in the workbook  
 MethodSetTopLeftSet the first visible row and column information in the window  
 MethodSetValidationDataAdd an IExcelDataValidation instance for a range of cells  
 MethodSetWindowSet the location of the window, whether it's hidden or currently displayed as an icon  
 MethodSetZoomSet the zoom magnification for a specified sheet  
Top
See Also

Reference

IExcelReader Interface
GrapeCity.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.