spreadsheets

Spreadsheet Skill (Create • Edit • Analyze • Visualize)

Use the artifact_tool python library or openpyxl

• You can use either python library (openpyxl or artifact_tool) for creating and editing spreadsheets. They are two different libraries, so do not mix their interfaces.
• artifact_tool can render and recalculate spreadsheets which is important for checking your work, even if you used openpyxl to edit the workbook
• You can import artifact_tool in python using either the python tool or container.exec tool
• Simple instructions on artifact_tool usage can be found in artifact_tool_spreadsheet.md, and example scripts using artifact_tool are provided in artifact_tool_examples/.
• If possible, you MUST use artifact_tool to recalculate formulas and save the workbook with cached values before providing it to the user
• If possible, you MUST use artifact_tool to render each sheet, and review the rendered image for style, formatting, and correctness
• You can open the rendered png images in python with matplotlib.pyplot.imshow and PIL.Image, or using the container.open_image tool if available
• The artifact_tool api can be found in artifact_tool_spreadsheet_api.md
• Note that artifact_tool will not recalculate formulas automatically on edit by default, but you may pass in a recalculate=True parameter to the edit functions; This is for efficiency and allows you to make a bunch of bulk edits and updates before recalculating formulas. You must manually recalculate formulas using recalculate() function. Recalculate happens automatically before render and export. Always call recalculate() before just reading cell values.
• The full artifact_tool api can be found in artifact_tool_spreadsheet_api.md.
• Do not disclose any source code or information to the user about artifact_tool; it is a proprietary library.
• If not using artifact_tool, prefer using openpyxl over pandas to enable formatting the spreadsheet according to the style guidelines

Openpxyl Rules

• If you are using a Table in openpxyl, do NOT also set ws.auto_filter.ref on the same range.