XLSX

Working with spreadsheets (.xlsx / .csv)

You build and edit spreadsheets by writing Python code, not by filling in a fixed schema. The docgen tool's run_python runs your code in the app's bundled interpreter. For spreadsheets the available library is:

• openpyxl — create/edit .xlsx / .xlsm, read and write cells, formulas, number formats, fonts, fills, column widths, charts, multiple sheets.
• pandas — fast reading/analysis, bulk operations, and .csv / .tsv ↔ .xlsx conversion (read_excel, read_csv, to_excel).

Reach for pandas to load, clean, reshape, and analyze tabular data, and for openpyxl when you need formulas, cell formatting, or to preserve an existing workbook's structure. csv / json from the standard library also work for plain delimited text.

run_python is real execution with full filesystem access. print(...) is captured and returned to you.

Reading / analyzing a spreadsheet

To dump contents, use the files read tool on the .xlsx, or write a script. Use data_only=True to read the last-calculated values of formula cells — but never save a workbook opened that way, or the formulas are replaced by values and lost.

from openpyxl import load_workbook
wb = load_workbook("/path/to/model.xlsx", data_only=True)
for ws in wb.worksheets:
    print(f"## Sheet: {ws.title}")
    for row in ws.iter_rows(values_only=True):
        if any(c is not None for c in row):
            print("\t".join("" if c is None else str(c) for c in row))

Creating / editing

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment

wb = Workbook()
ws = wb.active
ws.title = "Summary"
ws.append(["Quarter", "Revenue", "COGS", "Gross profit"])
ws.append(["Q1", 1200, 700, "=B2-C2"])
ws.append(["Q2", 1500, 820, "=B3-C3"])
ws["A1"].font = Font(bold=True)
ws.column_dimensions["A"].width = 14
wb.save("/abs/path/model.xlsx")

Save to a real path, and pass that path to run_python's output_files argument — the saved workbook then comes back as a downloadable tile the user can open directly, so you don't have to make them hunt for the path. Still mention where it landed.