“openpyxl”的搜索结果

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.

中文简介正在准备中。当前显示英语简介。

• Continuing Excel creation after sandbox errors
• Editing existing workbooks and adjusting column widths
• Checking saved workbook 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.

中文简介正在准备中。当前显示英语简介。

• Creating report titles that span multiple columns
• Formatting section headers and grouped labels
• Updating values in existing merged ranges

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.

中文简介正在准备中。当前显示英语简介。

• Fill an Excel template containing merged cells
• Resolve AttributeError when writing cell values
• Unmerge ranges across multiple worksheets

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.

中文简介正在准备中。当前显示英语简介。

• Retrying Excel creation after sandbox failures
• Creating spreadsheets with styles and formulas
• Building workbooks with multiple sheets

使用Python创建财务模型Excel文件，通过颜色区分输入值、公式和引用，添加来源批注与一致性检查，便于他人核验，并随假设调整更新计算结果。

• 创建可追溯数据来源的财务模型
• 比较不同假设下的企业估值
• 准备供他人审核的Excel文件

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.

中文简介正在准备中。当前显示英语简介。

• Create a workbook with formulas and formatting
• Edit an existing spreadsheet
• Restructure messy CSV or TSV data

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 exact sheet names and row counts
• Check sample size and category coverage
• Confirm required source sheets remain after editing

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.

中文简介正在准备中。当前显示英语简介。

• Resolve conflicting workbook reports from agents
• Check that spreadsheet edits were saved
• Count rows selected with a marker column

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.

中文简介正在准备中。当前显示英语简介。

• Recovering Excel creation after sandbox execution fails
• Creating schedules with colored headers and borders
• Formatting reports with alternating row colors

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.

中文简介正在准备中。当前显示英语简介。

• Creating an Excel file without opening Office
• Keeping model inputs and calculations on separate sheets
• Adding a sheet for financial consistency checks

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 an Excel workbook from a detailed specification
• Verify row counts and formulas after editing
• Identify the correct workbook among similar files

创建、读取和编辑Excel工作簿，并与CSV相互转换。可制作包含多张工作表、公式和图表的报表，也可追加数据行，在调整表格结构时修改公式引用。

• 制作带格式和图表的Excel报表
• 检查现有工作簿的数据和公式
• 追加数据行或调整表格结构

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.

中文简介正在准备中。当前显示英语简介。

• Transform revenue data and save a processed Excel workbook
• Apply calculations across multiple worksheets
• Format report headers with colors and alignment

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.

中文简介正在准备中。当前显示英语简介。

• Processing multiple Excel sheets in one script
• Calculating new columns from spreadsheet data
• Formatting report headers and cells

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.

中文简介正在准备中。当前显示英语简介。

• Checking required columns before processing Excel files
• Transforming data and saving a new workbook
• Updating formatting across multiple sheets

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.

中文简介正在准备中。当前显示英语简介。

• Create an Excel report with multiple sheets
• Apply data and formatting in one script
• Update cells in an existing XLSX file

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.

中文简介正在准备中。当前显示英语简介。

• Continuing Python work after sandbox import failures
• Creating Excel or Word files through shell commands
• Running multiline Python scripts with a heredoc

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.

中文简介正在准备中。当前显示英语简介。

• Investigating unclear errors returned by run_shell
• Diagnosing spreadsheet scripts that suddenly stop working
• Checking Python setup in a new environment or container

使用Python的openpyxl库读取两个Excel文件，将数据合并到一个新文件中，并确保去除重复行。

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示英语简介。

• Clean inconsistent CSV or TSV tables
• Build Excel reports with totals and charts
• Update an existing workbook while keeping its formatting

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.

中文简介正在准备中。当前显示英语简介。

• Create an Excel report with charts
• Build a financial model with adjustable assumptions
• Summarize data in interactive pivot tables

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 and format multiple Excel sheets
• Create PDF checklists
• Turn sales summaries into PDF reports

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.

中文简介正在准备中。当前显示英语简介。

• Transform data across multiple Excel sheets
• Apply consistent formatting to spreadsheet reports
• Generate PDF reports from spreadsheet data

Create or modify Excel workbooks, then independently check the saved file with Python. Verify required sheets, columns, populated cells, row counts, and sample selections against the requested structure before reporting the work as complete.

中文简介正在准备中。当前显示英语简介。

• Creating Excel workbooks from reference data
• Identifying the correct workbook before editing
• Checking required sheets, columns, and row counts