87 skills · sorted by relevance
Continue Excel file creation and editing when execute_code_sandbox repeatedly fails with openpyxl errors. Use run_shell to run Python directly, then check that the workbook was saved with the expected sheets and content.
Build Excel spreadsheets with merged titles and headers using openpyxl, a Python library for spreadsheet files. Follow a sequence for entering values, merging cells, and applying formatting, with guidance for updating existing merged ranges and checking saved results.
Create Excel files with openpyxl, a Python spreadsheet library, by switching to shell execution when sandbox tools fail. Examples cover cell styling, formulas, merged cells, multiple sheets, error reporting, and checking that the output file exists.
Handle merged cells before filling Excel templates with openpyxl, a Python library for spreadsheets. This skill shows how to inspect merged ranges, unmerge the required areas, write values, and save the workbook without merged-cell write errors.
Create financial Excel workbooks with Python, using formulas, color-coded inputs, source comments, and consistency checks. Build models that reviewers can trace and users can adjust by changing assumptions.
Create, edit, and clean spreadsheet files, including Excel workbooks and CSV data. Build formulas and formatting with openpyxl, a Python library, then recalculate and validate workbooks to check for formula errors and file problems.
Audit an Excel workbook before editing, then verify the saved file with Python and openpyxl. Each requested requirement receives an explicit status, so completion depends on checks of the actual file.
Verify saved Excel files directly with Python and openpyxl, a workbook library. Check sheets, headers, row counts, marked rows, and output files to resolve conflicting agent reports and summarize what actually exists on disk.
Create formatted Excel files when sandbox code execution fails by running Python through the shell. Uses openpyxl to add styled headers, alternating row colors, borders, alignment, and adjusted column widths.
Generate an Excel workbook file in an agent session without an open Office app. Use Python and openpyxl to organize inputs, formulas, and checks, then save the .xlsx file and return its relative path.
Create or edit Excel workbooks with checks for sheet names, row counts, formulas, and merged cells. Reopen the saved file and verify each requirement, recording explicit results rather than relying on a completion summary.
Create, inspect, and edit Excel workbooks using Python helper scripts. Build formatted reports with multiple sheets, formulas, and charts, update existing tables, adjust references during structural changes, and convert data between Excel and CSV.
Validate spreadsheet sources before running Python scripts to transform data, update multiple sheets, or apply formatting. Check required data first, try backup sources when needed, and report errors clearly if processing cannot proceed.
Process complex Excel files by running Python scripts directly through run_shell. Use pandas for data transformations and openpyxl for workbook editing, including multiple sheets, formulas, and formatting, with explicit saving and error reporting.
Process Excel workbooks by saving Python scripts to files and running them through the shell. Covers multiple sheets, data transformations, formulas, formatting, and error reporting for complex spreadsheet tasks.
Diagnose Python spreadsheet failures through staged checks of the interpreter, library imports, file access, and basic operations. Minimal test scripts help separate environment problems from errors in the full processing script.
Run Python through shell commands when sandbox execution fails because required packages are unavailable. The skill explains short commands, multiline scripts, package checks, and output verification, with examples for creating Excel and Word files.
Create and edit Excel workbooks by running a complete Python script through the shell. Covers multiple sheets, data entry, formatting, formulas, and saving files when other file-reading or code-execution tools fail.
使用Python的openpyxl库读取两个Excel文件，将数据合并到一个新文件中，并确保去除重复行。
The English summary is being prepared. Showing the original description.
Read, create, and edit Excel workbooks, including formulas, formatting, charts, and multiple sheets. Clean CSV or TSV tables and prepare spreadsheet deliverables, with guidance on choosing fixed calculated values or formulas that update later.
Create and edit Excel workbooks for data analysis, reports, and financial models. Build formulas that update with inputs, organize sheets, add charts and interactive pivot tables, and recalculate the workbook to check for formula errors.
Process Excel workbooks and generate PDF reports by running Python scripts directly. Covers multiple sheets, data transformations, formatting, and error handling, with scripts saved as files for complex tasks.
Create and process Excel files, PDF checklists, and structured reports by running Python scripts directly. The skill covers multiple sheets, formulas, formatting, data transformations, and error handling for document workflows with several steps.
Process Excel files with Python after checking that input files and source URLs are accessible. The workflow covers data transformations, formulas, and formatting, with alternative sources and error logs when access fails.