Changelog

All notable changes to this project are documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

1.0.0 - 2026-07-19 #

First public release.

Added #

• Workbook — open, create, save, sheetnames, worksheets, add_worksheet, rename_worksheet, remove_worksheet, properties (core document metadata). Opens .xlsx, .xlsm, .xltx / .xltm; VBA and unknown parts round-trip untouched.
• Cells — typed value (str, int, float, bool, date, datetime), formula, data_type, clear, offset, find / findall, iter_cells, iter_rows.
• Styles — cell.style read proxy, apply_style, apply_date_format, apply_number_format.
• Layout — column/row dimensions, merge_cells, unmerge_cells, merged_ranges, clear_range, write_rows, insert_rows, insert_columns.
• Images — add_image, images, Picture.replace, replace_image, insert_image_at_placeholder.
• Charts — add_chart, charts, read/set title, set_series_formula.
• Tables — add_table, tables, Table.resize.
• Conditional formatting — read blocks and rules; add_conditional_formatting (cellIs), add_color_scale_formatting, expand_conditional_formatting.
• Hyperlinks — cell.hyperlink with url, location, display.
• Search and replace — workbook/sheet replace (substring or whole-cell typed: text, number, date).
• Bulk export — write_dataframe, Workbook.export_to_template, write_rows, row/column styles, and Workbook.open(..., large=True) for big files.
• Pandas — optional engine="xlsxedit" for ExcelWriter and read_excel via xlsxedit.pandas_io.register().
• Typing — ships py.typed (PEP 561).
• Exceptions — XlsxeditError base with WorksheetNotFoundError, DuplicateWorksheetError, InvalidRangeError, InvalidColorError, InvalidImageError, and MissingPartError (each also subclasses the builtin it replaces).