Spread Silverlight Documentation
IExcelWriter Interface Members
Methods 

The following tables list the members exposed by IExcelWriter.

Public Methods
 NameDescription
 MethodFinishFinish - called after the Excel file has completed saving.  
 MethodGetAutoFilterGet the AutoFilter information for the specified sheet  
 MethodGetBuiltInNameListGet the built-in name information used in the workbook  
 MethodGetCalculationPropertyGets the current workbook calculation property.  
 MethodGetCellsGet all non empty cells used in the specified sheet.  
 MethodGetColorPaletteGet the color palette used in the workbook  
 MethodGetConditionalFormatGet all conditional formatting settings defined in the specified sheet.  
 MethodGetCustomOrFunctionNameListGet the custom and function name information used in the workbook  
 MethodGetDefaultColumnWidthGets the default column width of the specified sheet  
 MethodGetDefaultRowHeightGets the default row height of the specified sheet  
 MethodGetDifferentialFormattingRecordsGets the differential formatting settings used in the workbook  
 MethodGetDimensionsGet the minimum and maximum bounds of the sheet.  
 MethodGetDisplayElementsGets whether the specified sheet should show formula, show zeros, show gridlines, show row column headers, and whether its column is right to left.  
 MethodGetExcelCellFormatsGets the format settings used in the current workbook  
 MethodGetExcelDefaultCellFormatGet the default cell format setting  
 MethodGetExcelStylesGets the excel styles used in the current workbook  
 MethodGetExternWorkbookInfoGet the external referenced workbook information used in the workbook  
 MethodGetFrozenGets the frozen row and column count of the specified sheet  
 MethodGetGridlineColorGet the gridline color of the specified sheet.  
 MethodGetGuttersGets the row and column gutter settings of the specified sheet.  
 MethodGetInternalDefinedNamesGet all named cell ranged defined in the current workbook  
 MethodGetMergedCellsGet merged cells information of the specified sheet  
 MethodGetNonEmptyColumnsGet all non empty columns in the specified sheet.  
 MethodGetNonEmptyRowsGet all non empty row index in the specified sheet.  
 MethodGetOutlineDirectionGet the summary rows/columns directions  
 MethodGetPaletteColorGet the index of the closest color of the workbook color palette  
 MethodGetPaneGets the number and position of unfrozen panes in a window  
 MethodGetPrintAreaGet the print area setting of the specified sheet.  
 MethodGetPrintOptionsGets the print options of the sheet  
 MethodGetPrintPageMarginGets the print page margin information  
 MethodGetPrintPageSettingGets the print page setting of the sheet.  
 MethodGetPrintTitleGet the print title setting of the specified sheet.  
 MethodGetProtectGets the protection setting of the specified sheet  
 MethodGetScrollGets the scroll bars setting for the horizontal and vertical scroll bars.  
 MethodGetSelectionListGets the selection list of the specified sheet  
 MethodGetSheetCountGets the sheets count of the current workbook  
 MethodGetSheetNameGets the name of the sheet.  
 MethodGetTabsGet the tab settings of the current workbook  
 MethodGetThemeGet the theme used in the workbook  
 MethodGetTopLeftGets the first visible row and column information in the window  
 MethodGetValidationDataGets the data validation information for the specified sheet  
 MethodGetWindowGet the location of the window, whether it's hidden or currently displayed as an icon  
 MethodGetWorkbookPropertyGets the current workbook property setting  
 MethodGetZoomGets the zoom (scaling factor) for exporting to Excel file.  
 MethodIsCalculationErrorDetermine if the value is a calculation error; if it is, get the error id  
 MethodIsSheetHiddenGet the value which indicate whether the sheet is visible or hidden.  
 MethodOnExcelSaveErrorThis method will be invoked when exception or abnormal condition happens during save file.  
Top
See Also

Reference

IExcelWriter Interface
GrapeCity.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.