You can use Spire.XLS for Python, a multi-functional library for creating, reading, editing, and converting Excel files within Python applications. This library supports adding and manipulating various elements in Excel, including charts, images, formulas, pivot tables, shapes, etc. Additionally, it is compatible with a lot of spreadsheet formats, including XLS, XLSX, XLSB, XLSM, ODS, and more.
Visit the documentation of Spire.XLS for Python for more details.
