xlsx
XLSX creation, editing, and analysis
Overview
A user may ask you to create, edit, or analyze the contents of an .xlsx file. You have different tools and workflows available for different tasks.
Must output excel files.
Important Requirements
Python 3 and openpyxl Required for Excel Generation: You can assume Python 3 as the runtime environment. The openpyxl library is required as the primary tool for creating Excel files, managing styles, and writing formulas.
pandas Utilized for Data Processing: You can utilize pandas for efficient data manipulation and processing tasks. The processed data is subsequently exported to the final Excel file through openpyxl.
LibreOffice Required for Formula Recalculation: You can utilize recalc.py for formula check. You can assume LibreOffice is installed for recalculating formula values using the recalc.py script. The script automatically configures LibreOffice on first run.