The following tables list the members exposed by IExcelWriter.
Public Methods
| Name | Description | |
|---|---|---|
 | Finish | Finish - called after the Excel file has completed saving. |
| GetAutoFilter | Get the AutoFilter information for the specified sheet |
| GetBuiltInNameList | Get the built-in name information used in the workbook |
| GetCalculationProperty | Gets the current workbook calculation property. |
| GetCells | Get all non empty cells used in the specified sheet. |
| GetColorPalette | Get the color palette used in the workbook |
| GetConditionalFormat | Get all conditional formatting settings defined in the specified sheet. |
| GetCustomOrFunctionNameList | Get the custom and function name information used in the workbook |
| GetDefaultColumnWidth | Gets the default column width of the specified sheet |
| GetDefaultRowHeight | Gets the default row height of the specified sheet |
| GetDifferentialFormattingRecords | Gets the differential formatting settings used in the workbook |
| GetDimensions | Get the minimum and maximum bounds of the sheet. |
| GetDisplayElements | Gets whether the specified sheet should show formula, show zeros, show gridlines, show row column headers, and whether its column is right to left. |
| GetExcelCellFormats | Gets the format settings used in the current workbook |
| GetExcelDefaultCellFormat | Get the default cell format setting |
| GetExcelStyles | Gets the excel styles used in the current workbook |
| GetExternWorkbookInfo | Get the external referenced workbook information used in the workbook |
| GetFrozen | Gets the frozen row and column count of the specified sheet |
| GetGridlineColor | Get the gridline color of the specified sheet. |
| GetGutters | Gets the row and column gutter settings of the specified sheet. |
| GetInternalDefinedNames | Get all named cell ranged defined in the current workbook |
| GetMergedCells | Get merged cells information of the specified sheet |
| GetNonEmptyColumns | Get all non empty columns in the specified sheet. |
| GetNonEmptyRows | Get all non empty row index in the specified sheet. |
| GetOutlineDirection | Get the summary rows/columns directions |
| GetPaletteColor | Get the index of the closest color of the workbook color palette |
| GetPane | Gets the number and position of unfrozen panes in a window |
| GetPrintArea | Get the print area setting of the specified sheet. |
| GetPrintOptions | Gets the print options of the sheet |
| GetPrintPageMargin | Gets the print page margin information |
| GetPrintPageSetting | Gets the print page setting of the sheet. |
| GetPrintTitle | Get the print title setting of the specified sheet. |
| GetProtect | Gets the protection setting of the specified sheet |
| GetScroll | Gets the scroll bars setting for the horizontal and vertical scroll bars. |
| GetSelectionList | Gets the selection list of the specified sheet |
| GetSheetCount | Gets the sheets count of the current workbook |
| GetSheetName | Gets the name of the sheet. |
| GetTabs | Get the tab settings of the current workbook |
| GetTheme | Get the theme used in the workbook |
| GetTopLeft | Gets the first visible row and column information in the window |
| GetValidationData | Gets the data validation information for the specified sheet |
| GetWindow | Get the location of the window, whether it's hidden or currently displayed as an icon |
| GetWorkbookProperty | Gets the current workbook property setting |
| GetZoom | Gets the zoom (scaling factor) for exporting to Excel file. |
| IsCalculationError | Determine if the value is a calculation error; if it is, get the error id |
| IsSheetHidden | Get the value which indicate whether the sheet is visible or hidden. |
| OnExcelSaveError | This method will be invoked when exception or abnormal condition happens during save file. |
See Also