Spreadsheets

Use the @oai/artifact-tool Workbook API to add sheets, bulk-write values and formulas, apply formatting, and add native Excel charts from bounded source ranges. Export the result with SpreadsheetFile.exportXlsx and save it as an .xlsx file.

Import the workbook with SpreadsheetFile.importXlsx, inspect the target ranges first, then make minimal scoped edits. Extend dependent elements like conditional formatting ranges and chart source ranges when adding rows or columns.

It uses @oai/artifact-tool from the Codex workspace dependencies for authoring, editing, inspecting, rendering, and exporting .xlsx workbooks. Alternate libraries like openpyxl or xlsxwriter are only used if the user explicitly requests a fallback.

Yes, CSV text can be imported directly with Workbook.fromCSV, and the skill covers .xlsx, .xls, .csv, and .tsv formats. CSV data can be cleaned or analyzed with bundled Python libraries like pandas before workbook creation.

Formula errors typically come from bad references, off-by-one ranges, or cross-sheet formulas written before the referenced sheet exists. The skill runs a regex error scan over the workbook and inspects key ranges to catch and fix these before export.

Yes, a dedicated financial models template covers DCF, valuation, 3-statement models, and sensitivity tables. It enforces conventions like blue inputs, black formulas, checks sheets, and a finance audit pass before final export.