Skip to main content

ApiWorkbook

Class representing the currently active workbook

Methods​

The following table lists the available methods.

MethodReturnsDescription
GetActiveChartApiChart | nullReturns the active chart of the workbook.
GetActiveSheetApiWorksheetReturns the active sheet of the workbook.
GetAllPivotTablesApiPivotTable[]Returns all pivot tables in the workbook.
GetCustomPropertiesApiCustomPropertiesReturns the custom properties of the workbook.
GetDrawingsByNameDrawing[]Returns drawings with the specified names from the workbook.
GetNamestringReturns the name of the workbook.
GetSheetsApiWorksheet[]Returns a sheet collection that represents all the sheets in the workbook.
GetThemeApiThemeReturns the theme of the workbook.
SaveNoneSaves changes to the specified document.