Common Methods
Quick reference for the most frequently used methods. Click any interface name for full documentation.
| Method | Description |
|---|---|
| createWorkbook() | Create a new empty workbook |
| openWorkbook(path) | Open an existing XLSX file |
| save(wb, path) | Save workbook to XLSX |
| wb.getActiveSheet() | Get the currently active worksheet |
| wb.getSheetByName(name) | Get a sheet by name |
| wb.calculate() | Recalculate all formulas |
| wb.batch(fn) | Group operations into a single undo step |
| ws.setCell(ref, value) | Set a cell value or formula |
| ws.getValue(ref) | Read a cell's computed value |
| ws.setRange(ref, data) | Write a 2D array to a range |
| ws.getRange(ref) | Read a range as a 2D array |
| ws.tables.add({range, name}) | Create a structured table |
| ws.charts.add({type, range}) | Insert a chart from data |
| ws.pivots.add({source, dest}) | Create a pivot table |
| ws.to_dataframe() | Convert to pandas DataFrame (Python) |
Workbook
Workbook
62 methods
wb.sheets
10 methods
wb.slicers
8 methods
wb.slicerStyles
9 methods
wb.pivotTableStyles
5 methods
wb.functions
8 methods
wb.names
13 methods
wb.scenarios
6 methods
wb.history
9 methods
wb.styles
12 methods
wb.properties
6 methods
wb.protection
2 methods
wb.notifications
9 methods
wb.theme
4 methods
wb.viewport
5 methods
wb.changes
1 method
Worksheet
Worksheet
64 methods
ws.whatIf
2 methods
ws.smartArt
18 methods
ws.changes
1 method
ws.formats
19 methods
ws.layout
24 methods
ws.view
14 methods
ws.structure
14 methods
ws.charts
50 methods
ws.objects
16 methods
ws.shapes
4 methods
ws.pictures
3 methods
ws.textBoxes
3 methods
ws.drawings
3 methods
ws.equations
3 methods
ws.wordArt
3 methods
ws.connectors
2 methods
ws.filters
22 methods
ws.formControls
3 methods
ws.conditionalFormats
12 methods
ws.validation
8 methods
ws.tables
53 methods
ws.pivots
36 methods
ws.slicers
13 methods
ws.sparklines
18 methods
ws.comments
29 methods
ws.hyperlinks
3 methods
ws.outline
14 methods
ws.protection
9 methods
ws.print
19 methods
ws.settings
7 methods
ws.bindings
7 methods
ws.names
6 methods
ws.styles
3 methods
Types
460 type definitions. View all types →