# xlwings

> Documentation for xlwings, a Python library to automate Excel, write user-defined functions, and build interactive Excel tools.


Zoomer Analytics LLC

## Pages in this subsection

- [API Reference](index.md): * Top-level functions
- [Top-level functions](top_level_functions.md): Loads the selected cell(s) of the active workbook into a pandas DataFrame. If you
- [UDF decorators](udf_decorators.md): Functions decorated with `xlwings.func` will be imported as `Function` to Excel when running
- [App](app.md): An app corresponds to an Excel instance and should normally be used as context
- [Apps](apps.md): A collection of all `app` objects:
- [Book](book.md): A book object is a member of the `books` collection:
- [BookAsync](book_async.md): Type hint for the async API in xlwings Lite scripts.
- [Books](books.md): A collection of all `book` objects:
- [Characters](characters.md): The characters object can be accessed as an attribute of the range or shape
- [Chart](chart.md): The chart object is a member of the `charts` collection:
- [Charts](charts.md): A collection of all `chart` objects on the specified sheet:
- [Font](font.md): The font object can be accessed as an attribute of the range or shape object.
- [Name](name.md): The name object is a member of the `names` collection:
- [Names](names.md): A collection of all `name` objects in the workbook:
- [Note](note.md): Returns the native object (`pywin32` or `appscript` obj)
- [PageSetup](page_setup.md): Returns the native object (`pywin32` or `appscript` obj)
- [Picture](picture.md): The picture object is a member of the `pictures`
- [Pictures](pictures.md): A collection of all `picture` objects on the specified sheet:
- [Range](range.md): Returns a Range object that represents a cell or a range of cells.
- [RangeColumns](range_columns.md): Represents the columns of a range. Do not construct this class directly, use
- [RangeRows](range_rows.md): Represents the rows of a range. Do not construct this class directly, use
- [Reports](reports.md): Use this class to provide images to either `render_template()`.
- [Shape](shape.md): The shape object is a member of the `shapes` collection:
- [Shapes](shapes.md): A collection of all `shape` objects on the specified sheet:
- [Sheet](sheet.md): A sheet object is a member of the `sheets` collection:
- [Sheets](sheets.md): A collection of all `sheet` objects:
- [Table](table.md): The table object is a member of the `tables` collection:
- [Tables](tables.md): A collection of all `table` objects on the specified sheet:

## Optional

- [Top-level llms.txt](../llms.txt): Complete documentation index.