xlsx

Create, edit, and analyze Excel spreadsheets with formulas, formatting, and error-free calculations. Unless otherwise stated by the user or existing template 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. LibreOffice Required for Formula Recalculation : You can assume LibreOffice is installed for recalculating formula values using the scripts/recalc.py script. The script automatically configures LibreOffice on first run, including in sandboxed environments where Unix sockets are restricted (handled by scripts/office/soffice.py ) For data analysis, visualization, and basic operations, use pandas which provides powerful data manipulation capabilities: Always use Excel formulas instead of calculating values in Python and hardcoding them. This ensures the spreadsheet remains dynamic and updateable. This applies to ALL calculations - totals, percentages, ratios, differences, etc. The spreadsheet should be able to recalculate when source data changes.