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. |