Back to Details

excel

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Excel

Excel

Comprehensive Excel file manipulation - read, write, edit, format, and export.
全面的Excel文件处理功能——读取、写入、编辑、格式化和导出。

Setup

安装配置

bash
pip install openpyxl
bash
pip install openpyxl

Or use uv (recommended)

或使用uv（推荐）

uv run --with openpyxl python3 scripts/excel.py --help
undefined
uv run --with openpyxl python3 scripts/excel.py --help
undefined

Quick Reference

快速参考

bash
cd skills/excel
bash
cd skills/excel

Get file info

获取文件信息

python3 scripts/excel.py info report.xlsx
python3 scripts/excel.py info report.xlsx

Read entire sheet

读取整个工作表

python3 scripts/excel.py read report.xlsx python3 scripts/excel.py read report.xlsx --format markdown python3 scripts/excel.py read report.xlsx --sheet "Sales" --range A1:D10
python3 scripts/excel.py read report.xlsx python3 scripts/excel.py read report.xlsx --format markdown python3 scripts/excel.py read report.xlsx --sheet "Sales" --range A1:D10

Read specific cell

读取指定单元格

python3 scripts/excel.py cell report.xlsx B5
python3 scripts/excel.py cell report.xlsx B5

Create new workbook

创建新工作簿

python3 scripts/excel.py create output.xlsx python3 scripts/excel.py create output.xlsx --sheets "Data,Summary,Charts"
python3 scripts/excel.py create output.xlsx python3 scripts/excel.py create output.xlsx --sheets "Data,Summary,Charts"

Write data

写入数据

python3 scripts/excel.py write output.xlsx --data '[[1,2,3],[4,5,6]]' python3 scripts/excel.py write output.xlsx --data '{"headers":["Name","Age"],"rows":[["Alice",30],["Bob",25]]}'
python3 scripts/excel.py write output.xlsx --data '[[1,2,3],[4,5,6]]' python3 scripts/excel.py write output.xlsx --data '{"headers":["Name","Age"],"rows":[["Alice",30],["Bob",25]]}'

Edit a cell

编辑单元格

python3 scripts/excel.py edit report.xlsx A1 "New Value" python3 scripts/excel.py edit report.xlsx B2 "SUM(A1:A10)" --formula
python3 scripts/excel.py edit report.xlsx A1 "New Value" python3 scripts/excel.py edit report.xlsx B2 "SUM(A1:A10)" --formula

Export

导出

python3 scripts/excel.py to-csv report.xlsx output.csv python3 scripts/excel.py to-json report.xlsx output.json python3 scripts/excel.py to-markdown report.xlsx
undefined
python3 scripts/excel.py to-csv report.xlsx output.csv python3 scripts/excel.py to-json report.xlsx output.json python3 scripts/excel.py to-markdown report.xlsx
undefined

Commands

命令说明

Reading Data

读取数据

info - Get workbook metadata
bash
python3 scripts/excel.py info report.xlsx
info - 获取工作簿元数据
bash
python3 scripts/excel.py info report.xlsx

Returns: sheets, dimensions, row/column counts

返回：工作表列表、维度、行/列数量


**read** - Read sheet data
```bash
python3 scripts/excel.py read file.xlsx                     # JSON output
python3 scripts/excel.py read file.xlsx --format csv        # CSV output
python3 scripts/excel.py read file.xlsx --format markdown   # Markdown table
python3 scripts/excel.py read file.xlsx --sheet "Sheet2"    # Specific sheet
python3 scripts/excel.py read file.xlsx --range A1:D10      # Specific range
cell - Read a specific cell
bash
python3 scripts/excel.py cell file.xlsx A1
python3 scripts/excel.py cell file.xlsx B5 --sheet "Data"

**read** - 读取工作表数据
```bash
python3 scripts/excel.py read file.xlsx                     # JSON格式输出
python3 scripts/excel.py read file.xlsx --format csv        # CSV格式输出
python3 scripts/excel.py read file.xlsx --format markdown   # Markdown表格输出
python3 scripts/excel.py read file.xlsx --sheet "Sheet2"    # 指定工作表
python3 scripts/excel.py read file.xlsx --range A1:D10      # 指定单元格范围
cell - 读取指定单元格
bash
python3 scripts/excel.py cell file.xlsx A1
python3 scripts/excel.py cell file.xlsx B5 --sheet "Data"

Returns: value, formula (if any), data type, merge status

返回：单元格值、公式（如有）、数据类型、合并状态

undefined
undefined

Creating & Writing

创建与写入

create - Create new workbook
bash
python3 scripts/excel.py create new.xlsx
python3 scripts/excel.py create new.xlsx --sheets "Sheet1,Sheet2,Summary"
write - Write data to cells
bash
undefined
create - 创建新工作簿
bash
python3 scripts/excel.py create new.xlsx
python3 scripts/excel.py create new.xlsx --sheets "Sheet1,Sheet2,Summary"
write - 向单元格写入数据
bash
undefined

2D array

二维数组格式

python3 scripts/excel.py write file.xlsx --data '[[1,2,3],[4,5,6]]'
python3 scripts/excel.py write file.xlsx --data '[[1,2,3],[4,5,6]]'

With headers

带表头格式

python3 scripts/excel.py write file.xlsx --data '{"headers":["A","B"],"rows":[[1,2],[3,4]]}'
python3 scripts/excel.py write file.xlsx --data '{"headers":["A","B"],"rows":[[1,2],[3,4]]}'

Start at specific cell

从指定单元格开始写入

python3 scripts/excel.py write file.xlsx --data '[[1,2]]' --start C5
python3 scripts/excel.py write file.xlsx --data '[[1,2]]' --start C5

Key-value pairs

键值对格式

python3 scripts/excel.py write file.xlsx --data '{"Name":"Alice","Age":30}'

**from-csv** - Create Excel from CSV
```bash
python3 scripts/excel.py from-csv data.csv output.xlsx
python3 scripts/excel.py from-csv data.csv output.xlsx --sheet "Imported"
from-json - Create Excel from JSON
bash
python3 scripts/excel.py from-json data.json output.xlsx
python3 scripts/excel.py write file.xlsx --data '{"Name":"Alice","Age":30}'

**from-csv** - 从CSV文件创建Excel工作簿
```bash
python3 scripts/excel.py from-csv data.csv output.xlsx
python3 scripts/excel.py from-csv data.csv output.xlsx --sheet "Imported"
from-json - 从JSON文件创建Excel工作簿
bash
python3 scripts/excel.py from-json data.json output.xlsx

Supports: array of objects, array of arrays, headers+rows format

支持格式：对象数组、数组数组、表头+行数据格式

undefined
undefined

Editing

编辑操作

edit - Edit a cell value or formula
bash
python3 scripts/excel.py edit file.xlsx A1 "New Value"
python3 scripts/excel.py edit file.xlsx B2 100
python3 scripts/excel.py edit file.xlsx C3 "SUM(A1:B2)" --formula
python3 scripts/excel.py edit file.xlsx D4 "=VLOOKUP(A1,Data!A:B,2,FALSE)" --formula
find - Search for text
bash
python3 scripts/excel.py find file.xlsx "search term"
python3 scripts/excel.py find file.xlsx "error" --sheet "Log"
edit - 编辑单元格值或公式
bash
python3 scripts/excel.py edit file.xlsx A1 "New Value"
python3 scripts/excel.py edit file.xlsx B2 100
python3 scripts/excel.py edit file.xlsx C3 "SUM(A1:B2)" --formula
python3 scripts/excel.py edit file.xlsx D4 "=VLOOKUP(A1,Data!A:B,2,FALSE)" --formula
find - 搜索文本内容
bash
python3 scripts/excel.py find file.xlsx "search term"
python3 scripts/excel.py find file.xlsx "error" --sheet "Log"

Returns: list of cells containing the text

返回：包含指定文本的单元格列表


**replace** - Find and replace
```bash
python3 scripts/excel.py replace file.xlsx "old" "new"
python3 scripts/excel.py replace file.xlsx "2024" "2025" --sheet "Dates"

**replace** - 查找并替换内容
```bash
python3 scripts/excel.py replace file.xlsx "old" "new"
python3 scripts/excel.py replace file.xlsx "2024" "2025" --sheet "Dates"

Sheet Management

工作表管理

add-sheet - Add a new sheet
bash
python3 scripts/excel.py add-sheet file.xlsx "NewSheet"
python3 scripts/excel.py add-sheet file.xlsx "First" --position 0  # Insert at beginning
rename-sheet - Rename a sheet
bash
python3 scripts/excel.py rename-sheet file.xlsx "Sheet1" "Data"
delete-sheet - Delete a sheet
bash
python3 scripts/excel.py delete-sheet file.xlsx "OldSheet"
copy-sheet - Copy a sheet
bash
python3 scripts/excel.py copy-sheet file.xlsx "Template" "January"
add-sheet - 添加新工作表
bash
python3 scripts/excel.py add-sheet file.xlsx "NewSheet"
python3 scripts/excel.py add-sheet file.xlsx "First" --position 0  # 插入到开头
rename-sheet - 重命名工作表
bash
python3 scripts/excel.py rename-sheet file.xlsx "Sheet1" "Data"
delete-sheet - 删除工作表
bash
python3 scripts/excel.py delete-sheet file.xlsx "OldSheet"
copy-sheet - 复制工作表
bash
python3 scripts/excel.py copy-sheet file.xlsx "Template" "January"

Row & Column Operations

行与列操作

insert-rows - Insert rows
bash
python3 scripts/excel.py insert-rows file.xlsx 5              # Insert 1 row at row 5
python3 scripts/excel.py insert-rows file.xlsx 5 --count 3    # Insert 3 rows
insert-cols - Insert columns
bash
python3 scripts/excel.py insert-cols file.xlsx C              # Insert at column C
python3 scripts/excel.py insert-cols file.xlsx 3 --count 2    # Insert 2 cols at position 3
delete-rows - Delete rows
bash
python3 scripts/excel.py delete-rows file.xlsx 5
python3 scripts/excel.py delete-rows file.xlsx 5 --count 3
delete-cols - Delete columns
bash
python3 scripts/excel.py delete-cols file.xlsx C
python3 scripts/excel.py delete-cols file.xlsx B --count 2
insert-rows - 插入行
bash
python3 scripts/excel.py insert-rows file.xlsx 5              # 在第5行插入1行
python3 scripts/excel.py insert-rows file.xlsx 5 --count 3    # 插入3行
insert-cols - 插入列
bash
python3 scripts/excel.py insert-cols file.xlsx C              # 在C列位置插入列
python3 scripts/excel.py insert-cols file.xlsx 3 --count 2    # 在第3列位置插入2列
delete-rows - 删除行
bash
python3 scripts/excel.py delete-rows file.xlsx 5
python3 scripts/excel.py delete-rows file.xlsx 5 --count 3
delete-cols - 删除列
bash
python3 scripts/excel.py delete-cols file.xlsx C
python3 scripts/excel.py delete-cols file.xlsx B --count 2

Cell Operations

单元格操作

merge - Merge cells
bash
python3 scripts/excel.py merge file.xlsx A1:C1
python3 scripts/excel.py merge file.xlsx A1:A5 --sheet "Header"
unmerge - Unmerge cells
bash
python3 scripts/excel.py unmerge file.xlsx A1:C1
merge - 合并单元格
bash
python3 scripts/excel.py merge file.xlsx A1:C1
python3 scripts/excel.py merge file.xlsx A1:A5 --sheet "Header"
unmerge - 取消合并单元格
bash
python3 scripts/excel.py unmerge file.xlsx A1:C1

Formatting

格式化操作

format - Apply cell formatting
bash
undefined
format - 应用单元格格式
bash
undefined

Bold and italic

加粗和斜体

python3 scripts/excel.py format file.xlsx A1:D1 --bold --italic
python3 scripts/excel.py format file.xlsx A1:D1 --bold --italic

Font settings

字体设置

python3 scripts/excel.py format file.xlsx A1:D1 --font-size 14 --font-color RED --font-name "Arial"
python3 scripts/excel.py format file.xlsx A1:D1 --font-size 14 --font-color RED --font-name "Arial"

Background color

背景颜色

python3 scripts/excel.py format file.xlsx A1:D1 --bg-color YELLOW
python3 scripts/excel.py format file.xlsx A1:D1 --bg-color YELLOW

Alignment

对齐方式

python3 scripts/excel.py format file.xlsx A:A --align center --valign top
python3 scripts/excel.py format file.xlsx A:A --align center --valign top

Text wrapping

文本自动换行

python3 scripts/excel.py format file.xlsx B2:B100 --wrap
python3 scripts/excel.py format file.xlsx B2:B100 --wrap

Borders

边框设置

python3 scripts/excel.py format file.xlsx A1:D10 --border thin
python3 scripts/excel.py format file.xlsx A1:D10 --border thin

Border styles: thin, medium, thick, double

边框样式：thin（细边框）、medium（中等边框）、thick（粗边框）、double（双边框）

Combined

组合格式设置

python3 scripts/excel.py format file.xlsx A1:D1 --bold --bg-color "#4472C4" --font-color WHITE --align center

**resize** - Resize rows and columns
```bash
python3 scripts/excel.py resize file.xlsx --row 1:30          # Row 1 height = 30
python3 scripts/excel.py resize file.xlsx --col A:20          # Column A width = 20
python3 scripts/excel.py resize file.xlsx --row 1:30 --col A:15 --col B:25
freeze - Freeze panes
bash
python3 scripts/excel.py freeze file.xlsx A2    # Freeze row 1
python3 scripts/excel.py freeze file.xlsx B1    # Freeze column A
python3 scripts/excel.py freeze file.xlsx B2    # Freeze row 1 and column A
python3 scripts/excel.py format file.xlsx A1:D1 --bold --bg-color "#4472C4" --font-color WHITE --align center

**resize** - 调整行高和列宽
```bash
python3 scripts/excel.py resize file.xlsx --row 1:30          # 设置第1行高度为30
python3 scripts/excel.py resize file.xlsx --col A:20          # 设置A列宽度为20
python3 scripts/excel.py resize file.xlsx --row 1:30 --col A:15 --col B:25
freeze - 冻结窗格
bash
python3 scripts/excel.py freeze file.xlsx A2    # 冻结第1行
python3 scripts/excel.py freeze file.xlsx B1    # 冻结A列
python3 scripts/excel.py freeze file.xlsx B2    # 冻结第1行和A列

Export

导出操作

to-csv - Export to CSV
bash
python3 scripts/excel.py to-csv file.xlsx output.csv
python3 scripts/excel.py to-csv file.xlsx data.csv --sheet "Data"
to-json - Export to JSON (first row as headers)
bash
python3 scripts/excel.py to-json file.xlsx output.json
to-csv - 导出为CSV格式
bash
python3 scripts/excel.py to-csv file.xlsx output.csv
python3 scripts/excel.py to-csv file.xlsx data.csv --sheet "Data"
to-json - 导出为JSON格式（首行作为表头）
bash
python3 scripts/excel.py to-json file.xlsx output.json

Outputs: [{"Header1": "val1", "Header2": "val2"}, ...]

输出格式：[{"Header1": "val1", "Header2": "val2"}, ...]


**to-markdown** - Export to markdown table
```bash
python3 scripts/excel.py to-markdown file.xlsx
python3 scripts/excel.py to-markdown file.xlsx --sheet "Summary"

**to-markdown** - 导出为Markdown表格
```bash
python3 scripts/excel.py to-markdown file.xlsx
python3 scripts/excel.py to-markdown file.xlsx --sheet "Summary"

Colors

颜色说明

Named colors: 
RED
, 
GREEN
, 
BLUE
, 
YELLOW
, 
WHITE
, 
BLACK
, 
GRAY
, 
ORANGE
, 
PURPLE
, 
PINK
, 
CYAN
Hex colors: 
#FF0000
, 
#4472C4
, 
00FF00
(with or without #)
预定义颜色：
RED
、
GREEN
、
BLUE
、
YELLOW
、
WHITE
、
BLACK
、
GRAY
、
ORANGE
、
PURPLE
、
PINK
、
CYAN
十六进制颜色：
#FF0000
、
#4472C4
、
00FF00
（带或不带#号均可）

Common Workflows

常见工作流

Create a report from data

从数据创建报表

bash
undefined
bash
undefined

Create workbook with data

从JSON数据创建工作簿

python3 scripts/excel.py from-json sales.json report.xlsx --sheet "Sales"
python3 scripts/excel.py from-json sales.json report.xlsx --sheet "Sales"

Format headers

格式化表头

python3 scripts/excel.py format report.xlsx A1:E1 --bold --bg-color "#4472C4" --font-color WHITE
python3 scripts/excel.py format report.xlsx A1:E1 --bold --bg-color "#4472C4" --font-color WHITE

Freeze header row

冻结表头行

python3 scripts/excel.py freeze report.xlsx A2
python3 scripts/excel.py freeze report.xlsx A2

Resize columns

调整列宽

python3 scripts/excel.py resize report.xlsx --col A:15 --col B:25 --col C:12
undefined
python3 scripts/excel.py resize report.xlsx --col A:15 --col B:25 --col C:12
undefined

Update existing report

更新现有报表

bash
undefined
bash
undefined

Add new row

插入新行

python3 scripts/excel.py insert-rows report.xlsx 2 python3 scripts/excel.py write report.xlsx --data '[["New Item", 100, 50]]' --start A2
python3 scripts/excel.py insert-rows report.xlsx 2 python3 scripts/excel.py write report.xlsx --data '[["New Item", 100, 50]]' --start A2

Update specific cell

更新指定单元格

python3 scripts/excel.py edit report.xlsx D10 "=SUM(D2:D9)" --formula
python3 scripts/excel.py edit report.xlsx D10 "=SUM(D2:D9)" --formula

Find and replace dates

查找并替换日期

python3 scripts/excel.py replace report.xlsx "2024" "2025"
undefined
python3 scripts/excel.py replace report.xlsx "2024" "2025"
undefined

Extract data for analysis

提取数据用于分析

bash
undefined
bash
undefined

Read as JSON for processing

以JSON格式读取数据用于后续处理

python3 scripts/excel.py read data.xlsx --format json > data.json
python3 scripts/excel.py read data.xlsx --format json > data.json

Read specific range as markdown

读取指定范围数据并输出为Markdown格式

python3 scripts/excel.py read data.xlsx --range A1:D20 --format markdown
python3 scripts/excel.py read data.xlsx --range A1:D20 --format markdown

Export specific sheet to CSV

导出指定工作表为CSV格式

python3 scripts/excel.py to-csv data.xlsx --sheet "Raw Data" export.csv
undefined
python3 scripts/excel.py to-csv data.xlsx --sheet "Raw Data" export.csv
undefined

Output Format

输出格式说明

All commands output JSON with 
success: true/false
:
json
{
  "success": true,
  "file": "report.xlsx",
  "sheet": "Sheet1",
  ...
}
Use 
--format markdown
or 
--format csv
with 
read
command for alternative output.
所有命令默认输出包含
success: true/false
的JSON格式：
json
{
  "success": true,
  "file": "report.xlsx",
  "sheet": "Sheet1",
  ...
}
使用
read
命令时，可通过
--format markdown
或
--format csv
参数指定其他输出格式。