officecli

分类: 工具与效率 | 上传者: iOfficeAI | 下载: 0 | 版本: v1.0（最新）

Create, analyze, proofread, and modify Office documents (.docx, .xlsx, .pptx) using the officecli CLI tool. Use when the user wants to create, inspect, check formatting, find issues, add charts, or modify Office documents.

更新日志: Source: GitHub https://github.com/iOfficeAI/OfficeCli

目录结构

当前层级: 根目录

📁 .github/
- 📁 workflows/
  - 📄 build.yml 1.6 KB
📁 examples/
- 📄 beautiful_charts.xlsx 18.0 KB
- 📄 beautiful_presentation.pptx 12.2 KB
- 📄 charts_demo.xlsx 8.7 KB
- 📄 complex_formulas.docx 3.6 KB
- 📄 complex_tables.docx 2.4 KB
- 📄 data_presentation.pptx 6.9 KB
- 📄 gen-beautiful-charts.sh 46.7 KB
- 📄 gen-beautiful-pptx.sh 30.4 KB
- 📄 gen-charts-demo.sh 24.5 KB
- 📄 gen-complex-tables.sh 27.6 KB
- 📄 gen-complex-textbox.sh 35.8 KB
- 📄 gen-formulas.sh 7.7 KB
- 📄 gen-video-pptx.pptx 73.5 KB
- 📄 gen-video-pptx.py 6.0 KB
- 📄 sales_report.xlsx 3.6 KB
📁 src/
- 📁 officecli/
  - 📁 Core/
    
    📄 DocumentHandlerFactory.cs 1.0 KB
    
    📄 DocumentIssue.cs 574 B
    
    📄 DocumentNode.cs 660 B
    
    📄 ExcelStyleManager.cs 16.9 KB
    
    📄 FormulaParser.cs 58.3 KB
    
    📄 GenericXmlQuery.cs 20.3 KB
    
    📄 IDocumentHandler.cs 2.2 KB
    
    📄 OutputFormatter.cs 5.1 KB
    
    📄 RawXmlHelper.cs 10.9 KB
    
    📄 ResidentClient.cs 4.2 KB
    
    📄 ResidentServer.cs 16.5 KB
  - 📁 Handlers/
    
    📁 Excel/
    
    📄 ExcelHandler.Add.cs 18.4 KB
    
    📄 ExcelHandler.Helpers.cs 7.4 KB
    
    📄 ExcelHandler.Query.cs 5.3 KB
    
    📄 ExcelHandler.Selector.cs 6.4 KB
    
    📄 ExcelHandler.Set.cs 5.6 KB
    
    📄 ExcelHandler.View.cs 8.7 KB
    
    📁 Pptx/
    
    📄 PowerPointHandler.Add.cs 68.7 KB
    
    📄 PowerPointHandler.Animations.cs 32.3 KB
    
    📄 PowerPointHandler.Background.cs 10.4 KB
    
    📄 PowerPointHandler.Chart.cs 48.8 KB
    
    📄 PowerPointHandler.Effects.cs 5.3 KB
    
    📄 PowerPointHandler.Fill.cs 16.1 KB
    
    📄 PowerPointHandler.Helpers.cs 7.0 KB
    
    📄 PowerPointHandler.Hyperlinks.cs 2.5 KB
    
    📄 PowerPointHandler.NodeBuilder.cs 25.0 KB
    
    📄 PowerPointHandler.Notes.cs 5.2 KB
    
    📄 PowerPointHandler.Query.cs 24.6 KB
    
    📄 PowerPointHandler.Selector.cs 5.1 KB
    
    📄 PowerPointHandler.Set.cs 38.0 KB
    
    📄 PowerPointHandler.ShapeProperties.cs 26.4 KB
    
    📄 PowerPointHandler.View.cs 11.9 KB
    
    📁 Word/
    
    📄 WordHandler.Add.cs 32.9 KB
    
    📄 WordHandler.Helpers.cs 9.0 KB
    
    📄 WordHandler.ImageHelpers.cs 4.6 KB
    
    📄 WordHandler.Navigation.cs 12.1 KB
    
    📄 WordHandler.Query.cs 7.8 KB
    
    📄 WordHandler.Selector.cs 8.3 KB
    
    📄 WordHandler.Set.cs 22.6 KB
    
    📄 WordHandler.StyleList.cs 13.9 KB
    
    📄 WordHandler.View.cs 16.4 KB
    
    📄 ExcelHandler.cs 8.5 KB
    
    📄 PowerPointHandler.cs 25.9 KB
    
    📄 WordHandler.cs 5.4 KB
  - 📄 BlankDocCreator.cs 17.6 KB
  - 📄 HelpCommands.cs 39.5 KB
  - 📄 officecli.csproj 681 B
  - 📄 Program.cs 25.2 KB
📁 tests/
- 📁 OfficeCli.Tests/
  - 📁 Core/
    
    📄 ExcelStyleManagerTests.cs 12.4 KB
    
    📄 FormulaParserTests.cs 10.0 KB
  - 📁 Functional/
    
    📄 ExcelFunctionalTests.cs 10.1 KB
    
    📄 PptxFunctionalTests.cs 59.4 KB
    
    📄 WordFunctionalTests.cs 12.7 KB
  - 📄 OfficeCli.Tests.csproj 892 B
📄 .gitignore 190 B
📄 build.sh 2.6 KB
📄 dev-install.sh 1.5 KB
📄 install.ps1 2.2 KB
📄 install.sh 2.7 KB
📄 LICENSE 11.1 KB
📄 officecli.slnx 219 B
📄 README.md 8.4 KB
📄 README_zh.md 8.3 KB
📄 SKILL.md 7.4 KB

SKILL.md

---
name: officecli
description: Create, analyze, proofread, and modify Office documents (.docx, .xlsx, .pptx) using the officecli CLI tool. Use when the user wants to create, inspect, check formatting, find issues, add charts, or modify Office documents.
---

# officecli

AI-friendly CLI for .docx, .xlsx, .pptx.

**First, check if officecli is available:**
```bash
officecli --version
```
If the command is not found, install it:
```bash
curl -fsSL https://raw.githubusercontent.com/iOfficeAI/OfficeCli/main/install.sh | bash
```
For Windows (PowerShell):
```powershell
irm https://raw.githubusercontent.com/iOfficeAI/OfficeCli/main/install.ps1 | iex
```

**Strategy:** L1 (read) → L2 (DOM edit) → L3 (raw XML). Always prefer higher layers. Add `--json` for structured output.

**Performance:** Use `open <file>`/`close <file>` when running multiple commands on the same file to avoid repeated loading.

**Batch:** For 3+ operations, plan all changes first, generate a single script (work backwards on inserts), execute once.

---

## L1: Create, Read & Inspect

```bash
officecli create <file>          # create blank .docx/.xlsx/.pptx (type inferred from extension)
officecli view <file> outline|stats|issues|text|annotated [--start N --end N] [--max-lines N] [--cols A,B]
officecli get <file> '<path>' --depth 2 [--json]
officecli query <file> 'paragraph[style=Normal] > run[font!=宋体]'
```

**get paths:** Any XML localName works. Common paths: `/body/p[3]`, `/Sheet1/A1`, `/slide[1]/shape[1]`, `/slide[1]/table[1]/tr[1]/tc[1]`, `/slide[1]/placeholder[title]`. Use `--depth N` to expand children.

**view modes:** `outline` (structure), `stats` (statistics with style inheritance), `issues` (`--type format|content|structure`, `--limit N`), `text` (plain with line numbers), `annotated` (with formatting)

**query selectors:** `[attr=value]`, `[attr!=value]`, `:contains("text")`, `:empty`, `:has(formula)`, `:no-alt`. Built-in types: `paragraph`, `run`, `picture`, `equation`, `cell`, `table`, `placeholder`. Falls back to generic XML element name (e.g. `wsp`, `a:ln`, `srgbClr[val=0070C0]`).

For large documents, ALWAYS use `--max-lines` or `--start`/`--end` to limit output.

---

## L2: DOM Operations

### set — `officecli set <file> <path> --prop key=value [--prop ...]`

**Any XML attribute is settable via element path** (found via `get --depth N`) — even attributes not currently present. Use this before reaching for L3.

| Target | Path example | Properties |
|--------|-------------|------------|
| Word run | `/body/p[3]/r[1]` | `text`, `font`, `size`, `bold`, `italic`, `caps`, `smallCaps`, `strike`, `dstrike`, `vanish`, `outline`, `shadow`, `emboss`, `imprint`, `noProof`, `rtl`, `highlight`, `color`, `underline`, `shd`, ... |
| Word run image | `/body/p[5]/r[1]` | `alt`, `width`, `height` (cm/in/pt/px), ... |
| Word paragraph | `/body/p[3]` | `style`, `alignment`, `firstLineIndent`, `shd`, `spaceBefore`, `spaceAfter`, `lineSpacing`, `numId`, `numLevel`/`ilvl`, `listStyle`(=bullet\|numbered), ... |
| Word table cell | `/body/tbl[1]/tr[1]/tc[1]` | `text`, `font`, `size`, `bold`, `italic`, `color`, `shd`, `alignment`, `valign`(top\|center\|bottom), `width`, `vmerge`, `gridspan`, ... |
| Word table row | `/body/tbl[1]/tr[1]` | `height`, `header`(bool), ... |
| Word table | `/body/tbl[1]` | `alignment`, `width`, ... |
| Word document | `/` | `defaultFont`, `pageBackground`, `pageWidth`, `pageHeight`, `marginTop/Bottom/Left/Right`, ... |
| Excel cell | `/Sheet1/A1` | `value`, `formula`, `clear`, `font.bold/italic/strike/underline/color/size/name`, `fill`(hex RGB), `alignment.horizontal/vertical/wrapText`, `numFmt`, `link`(url/none) |
| PPT slide | `/slide[1]` | `background`(hex/gradient/`image:path`/none), `transition`(fade/wipe/push/…), `advanceTime`(ms), `advanceClick`(bool) |
| PPT notes | `/slide[1]/notes` | `text` |
| PPT shape | `/slide[1]/shape[1]` | `text`(`\n` for line breaks), `name`, `font`, `size`, `bold`, `italic`, `underline`, `strikethrough`, `color`, `fill`, `gradient`(e.g. `FF0000-0000FF-90`), `line`, `lineWidth`, `lineDash`, `preset`, `margin`, `align`, `valign`, `list`(bullet/numbered/alpha/roman), `lineSpacing`, `spaceBefore`, `spaceAfter`, `rotation`, `opacity`, `autoFit`, `shadow`(hex), `glow`(hex), `reflection`(true/none), `animation`(effect-class-ms), `link`(url/none), `x`, `y`, `width`, `height` |
| PPT table | `/slide[1]/table[1]` | `x`, `y`, `width`, `height`, `name`, ... |
| PPT table row | `/slide[1]/table[1]/tr[1]` | `height`; other props (text, bold, fill, ...) apply to all cells in row |
| PPT table cell | `/slide[1]/table[1]/tr[1]/tc[1]` | `text`, `font`, `size`, `bold`, `italic`, `color`, `fill`, `align`, `gridspan`/`colspan`, `rowspan`, `vmerge`, `hmerge` |
| PPT placeholder | `/slide[1]/placeholder[title]` | Same as shape. Types: `title`, `body`, `subtitle`, `date`, `footer`, `slidenum`. Auto-created from layout if missing. |

Composite props (`pBdr`, `tabs`, `lang`, `bdr`) → use L3 (`raw-set --action setattr`).

### add — `officecli add <file> <parent> --type <type> [--index N] [--prop ...]` or `--from <path>`

| Format | Types & props |
|--------|--------------|
| Word | `paragraph`(text,font,size,bold,style,alignment,...), `run`(text,font,size,bold,italic,...), `table`(rows,cols), `picture`(path,width,height,alt,...), `equation`(formula,mode), `comment`(text,author,initials,date,...) |
| Excel | `sheet`(name), `row`(cols), `cell`(ref,value,formula,...), `databar`(sqref,min,max,color,...) |
| PPT | `slide`(title,text), `shape`(text,font,size,name,bold,italic,underline,strikethrough,color,fill,gradient,line,lineWidth,lineDash,preset,margin,align,valign,list,lineSpacing,spaceBefore,spaceAfter,rotation,opacity,autoFit,shadow,glow,reflection,animation,link,x,y,width,height), `table`(rows,cols,x,y,width,height; cells: gridspan,rowspan,vmerge,hmerge), `picture`(path,width,height,x,y,alt), `equation`(formula,x,y,width,height) |

Dimensions: raw EMU or suffixed `cm`/`in`/`pt`/`px`. Equation formula: LaTeX subset. `--from <path>` clones an existing element (cross-part relationships handled automatically).

### move — `officecli move <file> <path> [--to <parent>] [--index N]`

### remove — `officecli remove <file> '<path>'`

---

## L3: Raw XML

Use for charts, borders, or any structure L2 cannot express. **No xmlns needed** — prefixes auto-registered: `w`, `a`, `p`, `x`, `r`, `c`, `xdr`, `wp`, `wps`, `mc`, `wp14`, `v`

```bash
officecli raw <file> /document                     # Word: /styles, /numbering, /settings, /header[N], /footer[N]
officecli raw <file> /Sheet1 --start 1 --end 100 --cols A,B   # Excel: /styles, /sharedstrings, /<Sheet>/drawing, /<Sheet>/chart[N]
officecli raw <file> /slide[1]                     # PPT: /presentation, /slideMaster[N], /slideLayout[N]
officecli raw-set <file> /document --xpath "//w:body/w:p[1]" --action replace --xml '<w:p>...</w:p>'
# actions: append, prepend, insertbefore, insertafter, replace, remove, setattr
officecli add-part <file> /Sheet1 --type chart     # returns relId for use with raw-set
officecli add-part <file> / --type header|footer   # Word only
```

---

## Notes

- Paths are **1-based** (XPath convention), quote brackets: `'/body/p[3]'`
- `--index` is **0-based** (array convention): `--index 0` = first position
- After modifications, verify with `validate` and/or `view issues`
- `raw-set`/`add-part` auto-validate after execution
- `view stats`/`annotated` resolve style inheritance (docDefaults → basedOn → direct)

登录后下载/点赞/收藏 ❤ 3 | ★ 0

officecli

目录结构

SKILL.md

举报内容

提示