python-openpyxl
Using openpyxl to read, write, and modify Excel files while preserving formatting and using formulas.
- License 许可
- MIT
- 最近更新
- 2026-10-02
- Stars
- ★ 93
- Forks
- 8
01 前言 Front Matter
- name
- python-openpyxl
- description
- Using openpyxl to read, write, and modify Excel files while preserving formatting and using formulas.
03 SKILL.md 正文
python-openpyxl
openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
Installation
pip install openpyxl
Usage
Loading a Workbook
import openpyxl
wb = openpyxl.load_workbook("file.xlsx")
sheet = wb["Sheet1"]
Writing Formulas
To write a formula, simply assign it as a string to the cell's value:
sheet["A1"] = "=SUM(B1:B10)"
sheet.cell(row=2, column=1, value="=VLOOKUP(C2, Data!A:Z, 2, FALSE)")
Saving
wb.save("file.xlsx")
04 同仓库更多 Skills
object_counter
Count occurrences of an object in the image using computer vision algorithm.
travel-planning-workflow
Invoke this skill when performing travel planning. It defines a structured workflow for generating itineraries. Following this workflow is essential to ensure the final plan satisfies user requirements.
bundled-dataset-search-tool
invoke this skill when you need to perform database search for travel planning. This skill provides some useful pre-packaged tools to look up accommodations, attractions, cities, driving distance, flights, and restaurants from the bundled dataset.
glm-output
Output-processing guidance for GLM tasks. Especially useful after glm-basics and glm-calibration when you need verifier-matching metrics from output.nc and a final /root/metrics.json.
glm-calibration
Calibration guidance for GLM tasks. Often most effective after glm-basics has clarified the setup; glm-output is the companion skill for exact final metric computation.
glm-basics
A good starting point for GLM calibration tasks. Use to inspect glm3.nml, confirm how GLM runs, and identify the relevant files before moving on to calibration and output evaluation.