Spread WPF 17
GrapeCity.Excel Namespace / IExcelWriter Interface
Methods

In This Topic
    IExcelWriter Interface Members
    In This Topic

    The following tables list the members exposed by IExcelWriter.

    Public Methods
     NameDescription
     MethodFinish - called after the Excel file has completed saving.  
     MethodGet the AutoFilter information for the specified sheet  
     MethodGet the built-in name information used in the workbook  
     MethodGets the current workbook calculation property.  
     MethodGet all non empty cells used in the specified sheet.  
     MethodGet the color palette used in the workbook  
     MethodGet all conditional formatting settings defined in the specified sheet.  
     MethodGet the custom and function name information used in the workbook  
     MethodGets the default column width of the specified sheet  
     MethodGets the default row height of the specified sheet  
     MethodGets the differential formatting settings used in the workbook  
     MethodGet the minimum and maximum bounds of the sheet.  
     MethodGets whether the specified sheet should show formula, show zeros, show gridlines, show row column headers, and whether its column is right to left.  
     MethodGets the format settings used in the current workbook  
     MethodGet the default cell format setting  
     MethodGets the excel styles used in the current workbook  
     MethodGet the external referenced workbook information used in the workbook  
     MethodGets the frozen row and column count of the specified sheet  
     MethodGet the gridline color of the specified sheet.  
     MethodGets the row and column gutter settings of the specified sheet.  
     MethodGet all named cell ranged defined in the current workbook  
     MethodGet merged cells information of the specified sheet  
     MethodGet all non empty columns in the specified sheet.  
     MethodGet all non empty row index in the specified sheet.  
     MethodGet the summary rows/columns directions  
     MethodGet the index of the closest color of the workbook color palette  
     MethodGets the number and position of unfrozen panes in a window  
     MethodGet the print area setting of the specified sheet.  
     MethodGets the print options of the sheet  
     MethodGets the print page margin information  
     MethodGets the print page setting of the sheet.  
     MethodGet the print title setting of the specified sheet.  
     MethodGets the protection setting of the specified sheet  
     MethodGets the scroll bars setting for the horizontal and vertical scroll bars.  
     MethodGets the selection list of the specified sheet  
     MethodGets the sheets count of the current workbook  
     MethodGets the name of the sheet.  
     MethodGet the tab settings of the current workbook  
     MethodGet the theme used in the workbook  
     MethodGets the first visible row and column information in the window  
     MethodGets the data validation information for the specified sheet  
     MethodGet the location of the window, whether it's hidden or currently displayed as an icon  
     MethodGets the current workbook property setting  
     MethodGets the zoom (scaling factor) for exporting to Excel file.  
     MethodDetermine if the value is a calculation error; if it is, get the error id  
     MethodGet the value which indicate whether the sheet is visible or hidden.  
     MethodThis method will be invoked when exception or abnormal condition happens during save file.  
    Top
    See Also