huawei-noah/noah-research/xlsx

Claude Code and agent skill by huawei-noah/noah-research

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Use this skill whenever the user wants to do anything with Excel spreadsheet files (.xlsx, .xls, .csv). This includes reading data, writing formulas, manipulating cells, formatting, filtering, creating charts, pivot tables, and any spreadsheet automation tasks.

Install

npx vskill@latest install huawei-noah/noah-research/xlsx

SKILL.md

Excel Spreadsheet Processing

Use openpyxl to read and write .xlsx files.

Quick Start

python
from openpyxl import load_workbook
wb = load_workbook("input.xlsx")
ws = wb["Sheet1"]
value = ws["A1"].value
ws["B2"] = 42
ws["C2"] = "=SUM(A2:B2)"
wb.save("output.xlsx")

Use this for direct cell edits, formula updates, and simple workbook changes.

Reading Data with pandas

python
import pandas as pd
df = pd.read_excel('file.xlsx') # First sheet
all_sheets = pd.read_excel('file.xlsx', sheet_name=None) # All sheets as dict

Common Pitfalls

  • Cell indices are 1-based: ws.cell(row=1, column=1) is A1.
  • `data_only=True` destroys formulas on save: Use a separate workbook object for reading calculated values.
  • `ws.max_row` overcounts: May include formatted-but-empty rows. Scan the column to find the last non-empty cell when you need the true data range.

Security

  • Security scanPassed, 90 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

Repository stars
1,010
Repository forks
252
7-day trend score
35

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/huawei-noah/noah-research/xlsx/badge)](https://verified-skill.com/skills/huawei-noah/noah-research/xlsx)

Something wrong with this skill or its page? Tell us.