據 AlphaMoat 統計,截至 2026-10,xlsx-skill 累計下載 11,592 次、獲 0 個星標,按累計下載量在本次參與排名的 10,914 個 AI 技能中排名第 2,372 位,在「辦公效率」分類(909 個)中排名第 269 位。
列表預設按累計下載量排序,也可按星標排序;詳情頁排名按累計下載量計算。
| 平台 | 累計下載 | 星標 | 評論 |
|---|---|---|---|
| ClawHub ↗ | 1853 | - | - |
| SkillHub ↗ | 1.2萬 | - | — |
各平台的計數口徑不同,統計時間不一致。
使用 pandas、openpyxl 讀取資料、寫公式、樣式、表格、圖表與資料校驗,另列 xlsxwriter 為必需依賴。公式值需由 LibreOffice 等表格引擎重算,儲存公式不代表結果已計算。
資料釋出於 2026-10-27
以下是根據技能文件生成的示例,不代表實際執行結果。
2026-09 起統計方法調整:同名技能按作者分別統計,並覆蓋全部技能。圖中虛線為調整前的月份,與之後的資料不直接比較,也不計算跨越調整的增長。
| 月份 | 累計下載 | 環比 | 星標 |
|---|---|---|---|
| 2026-10 | 1.2萬 | — | - |
| 2026-09 | 5087 | — | - |
| 2026-08 | 3594 | +31.8% | - |
| 2026-07 | 2727 | — | - |
| 2026-05 | 1909 | — | - |
| 2026-03 | 776 | — | - |
以下是作者釋出的原始檔案,按純文字顯示,本站未做修改或稽核;其中的連結不可點選,命令請核實後再執行。抓取於 2026-10-23。
--- name: xlsx version: 2.0.0 description: Create, read, edit Excel spreadsheets (.xlsx, .xlsm, .csv). Supports formulas, formatting, charts, pivot tables, and data analysis with pandas. category: document-processing license: MIT --- # XLSX Skill v2.0
## Overview
Complete Excel spreadsheet processing using `openpyxl` for creation/editing and `pandas` for data analysis. Supports formulas, formatting, charts, and complex data operations.
## Installation & Dependencies
### Required
```bash
pip install pandas openpyxl xlsxwriter
```
### Optional
```bash
# For chart support
pip install numpy
# For PDF export
brew install --cask libreoffice
```
## Quick Start
### Read Excel File
```python
import pandas as pd
# Read first sheet
df = pd.read_excel('file.xlsx')
# Read specific sheet
df = pd.read_excel('file.xlsx', sheet_name='Sheet1')
# Read all sheets
all_sheets = pd.read_excel('file.xlsx', sheet_name=None)
```
### Create Excel File
```python
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws['A1'] = 'Hello'
ws['B1'] = 'World'
wb.save('output.xlsx')
```
### Add Formula
```python
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws['A1'] = 10
ws['A2'] = 20
ws['A3'] = '=SUM(A1:A2)' # Excel formula
wb.save('formula.xlsx')
```
## Complete API Reference
### Reading Data with pandas
```python
import pandas as pd
# Basic read
df = pd.read_excel('data.xlsx')
# Read specific columns
df = pd.read_excel('data.xlsx', usecols=['A', 'B', 'C'])
# Read with header row
df = pd.read_excel('data.xlsx', header=0)
# Read without header
df = pd.read_excel('data.xlsx', header=None)
# Read specific rows
df = pd.read_excel('data.xlsx', skiprows=range(1, 10)) # Skip rows 1-9
# Read multiple sheets
sheets_dict = pd.read_excel('data.xlsx', sheet_name=None)
for sheet_name, df in sheets_dict.items():
print(f"Sheet: {sheet_name}, Rows: {len(df)}")
# Data exploration
df.head() # First 5 rows
df.tail() # Last 5 rows
df.info() # Column info
df.describe() # Statistics
df.shape # (rows, columns)
df.columns # Column names
df.dtypes # Data types
```
### Writing Data with pandas
```python
import pandas as pd
# Create DataFrame
df = pd.DataFrame({
'Name': ['Alice', 'Bob', 'Charlie'],
'Age': [25, 30, 35],
'City': ['NYC', 'LA', 'Chicago']
})
# Write to Excel
df.to_excel('output.xlsx', index=False)
# Write to specific sheet
df.to_excel('output.xlsx', sheet_name='Data', index=False)
# Write multiple sheets
with pd.ExcelWriter('multi-sheet.xlsx') as writer:
df1.to_excel(writer, sheet_name='Sheet1', index=False)
df2.to_excel(writer, sheet_name='Sheet2', index=False)
```
### Creating with openpyxl
```python
from openpyxl import Workbook
from openpyxl.styles import Font, Fill, PatternFill, Border, Side, Alignment, Color
from openpyxl.utils import get_column_letter
wb = Workbook()
ws = wb.active
ws.title = "Data"
# Write values
ws['A1'] = 'Header 1'
ws['B1'] = 'Header 2'
ws.append(['Row 1 Col 1', 'Row 1 Col 2'])
ws.append(['Row 2 Col 1', 'Row 2 Col 2'])
# Cell formatting
ws['A1'].font = Font(bold=True, size=14, color='FFFFFF')
ws['A1'].fill = PatternFill('solid', start_color='4472C4')
ws['A1'].alignment = Alignment(horizontal='center')
# Column width
ws.column_dimensions['A'].width = 20
ws.column_dimensions['B'].width = 15
# Row height
ws.row_dimensions[1].height = 25
# Merge cells
ws.merge_cells('A1:B1')
# Save
wb.save('formatted.xlsx')
```
### Formulas
```python
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
# Basic formulas
ws['A1'] = 10
ws['A2'] = 20
ws['A3'] = '=SUM(A1:A2)' # Sum
ws['A4'] = '=AVERAGE(A1:A2)' # Average
ws['A5'] = '=MAX(A1:A2)' # Maximum
ws['A6'] = '=MIN(A1:A2)' # Minimum
ws['A7'] = '=COUNT(A1:A2)' # Count numbers
# Cross-sheet references
wb.create_sheet('Sheet2')
ws2 = wb['Sheet2']
ws2['A1'] = '=Data!A1' # Reference to Sheet1
# Save and recalculate
wb.save('formulas.xlsx')
```
### Charts
```python
from openpyxl import Workbook
from openpyxl.chart import BarChart, Reference, LineChart, PieChart
wb = Workbook()
ws = wb.active
# Add data
data = [
['Category', 'Value'],
['A', 10],
['B', 15],
['C', 20],
['D', 25]
]
for row in data:
ws.append(row)
# Create bar chart
chart = BarChart()
chart.type = "col"
chart.style = 10
chart.title = "Sales Chart"
chart.y_axis.title = 'Value'
chart.x_axis.title = 'Category'
# Define data range
data_ref = Reference(ws, min_col=2, min_row=1, max_row=5)
cats = Reference(ws, min_col=1, min_row=2, max_row=5)
chart.add_data(data_ref, titles_from_data=True)
chart.set_categories(cats)
chart.shape = 4
ws.add_chart(chart, "E1")
wb.save('chart.xlsx')
```
### Tables
```python
from openpyxl import Workbook
from openpyxl.worksheet.table import Table, TableStyleInfo
wb = Workbook()
ws = wb.active
# Add data
data = [
['Name', 'Age', 'City'],
['Alice', 25, 'NYC'],
['Bob', 30, 'LA'],
['Charlie', 35, 'Chicago']
]
for row in data:
ws.append(row)
# Create table
tab = Table(displayName="Table1", ref="A1:C4")
style = TableStyleInfo(name="TableStyleMedium9", showFirstColumn=False,
showLastColumn=False, showRowStripes=True,
showColumnStripes=False)
tab.tableStyleInfo = style
ws.add_table(tab)
wb.save('table.xlsx')
```
### Conditional Formatting
```python
from openpyxl import Workbook
from openpyxl.formatting.rule import CellIsRule, FormulaRule
from openpyxl.styles import PatternFill
wb = Workbook()
ws = wb.active
# Add data
for i in range(1, 11):
ws.cell(row=i, column=1, value=i * 10)
# Highlight cells greater than 50
red_fill = PatternFill(start_color='FF0000', end_color='FF0000', fill_type='solid')
ws.conditional_formatting.add(
'A1:A10',
CellIsRule(operator='greaterThan', formula=['50'], fill=red_fill)
)
# Highlight even numbers with formula
green_fill = PatternFill(start_color='00FF00', end_color='00FF00', fill_type='solid')
ws.conditional_formatting.add(
'A1:A10',
FormulaRule(formula=['IS EVEN(A1)'], fill=green_fill)
)
wb.save('conditional.xlsx')
```
### Data Validation
```python
from openpyxl import Workbook
from openpyxl.worksheet.datavalidation import DataValidation
wb = Workbook()
ws = wb.active
# Dropdown list
dv = DataValidation(type="list", formula1='"Yes,No,Maybe'", allow_blank=True)
dv.error = "Please select from the list"
dv.errorTitle = "Invalid Selection"
ws.add_data_validation(dv)
dv.add('A1:A10')
# Number range
dv2 = DataValidation(type="whole", operator="between", formula1=["1", "100"])
dv2.error = "Enter a number between 1 and 100"
ws.add_data_validation(dv2)
dv2.add('B1:B10')
wb.save('validation.xlsx')
```
## Complete Examples
### Example 1: Financial Report
```python
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from openpyxl.utils import get_column_letter
wb = Workbook()
ws = wb.active
ws.title = "Financial Report"
# Styles
header_font = Font(bold=True, size=12, color='FFFFFF')
header_fill = PatternFill('solid', start_color='4472C4')
border = Border(
left=Side(style='thin'),
right=Side(style='thin'),
top=Side(style='thin'),
bottom=Side(style='thin')
)
center_align = Alignment(horizontal='center')
# Headers
headers = ['Category', 'Q1', 'Q2', 'Q3', 'Q4', 'Total']
ws.append(headers)
# Style header row
for cell in ws[1]:
cell.font = header_font
cell.fill = header_fill
cell.border = border
cell.alignment = center_align
# Data (blue for inputs, black for formulas)
data = [
['Revenue', 100000, 120000, 115000, 130000],
['COGS', 40000, 48000, 46000, 52000],
['Gross Profit', '=B2-B3', '=C2-C3', '=D2-D3', '=E2-E3'],
['Expenses', 30000, 32000, 31000, 33000],
['Net Income', '=B4-B5', '=C4-C5', '=D4-D5', '=E4-E5']
]
for row in data:
ws.append(row)
# Add Total formula for Q1 column
last_row = len(data) + 2
ws[f'B{last_row}'] = '=SUM(B2:B6)'
# Format as currency
for row in ws.iter_rows(min_row=2, max_row=last_row, min_col=2, max_col=6):
for cell in row:
cell.number_format = '$#,##0'
cell.border = border
# Column widths
ws.column_dimensions['A'].width = 15
for col in range(2, 7):
ws.column_dimensions[get_column_letter(col)].width = 12
wb.save('financial-report.xlsx')
print("✓ Financial report created!")
```
### Example 2: Sales Dashboard with pandas
```python
import pandas as pd
import numpy as np
# Create sample sales data
np.random.seed(42)
dates = pd.date_range('2024-01-01', periods=100, freq='D')
products = ['Product A', 'Product B', 'Product C']
regions = ['North', 'South', 'East', 'West']
data = {
'Date': np.random.choice(dates, 100),
'Product': np.random.choice(products, 100),
'Region': np.random.choice(regions, 100),
'Units': np.random.randint(1, 100, 100),
'Price': np.random.uniform(10, 100, 100)
}
df = pd.DataFrame(data)
df['Revenue'] = df['Units'] * df['Price']
# Analysis
summary = df.groupby('Product').agg({
'Units': 'sum',
'Revenue': 'sum'
}).round(2)
region_summary = df.groupby('Region').agg({
'Units': 'sum',
'Revenue': ['sum', 'mean']
}).round(2)
# Write to Excel with multiple sheets
with pd.ExcelWriter('sales-dashboard.xlsx', engine='openpyxl') as writer:
# Raw data
df.to_excel(writer, sheet_name='Raw Data', index=False)
# Product summary
summary.to_excel(writer, sheet_name='Product Summary')
# Region summary
region_summary.to_excel(writer, sheet_name='Region Summary')
# Pivot table
pivot = pd.pivot_table(df, values='Revenue', index='Product',
columns='Region', aggfunc='sum')
pivot.to_excel(writer, sheet_name='Pivot Table')
print("✓ Sales dashboard created!")
```
### Example 3: Invoice Generator
```python
from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from datetime import datetime
def create_invoice(invoice_num, client_name, items, output_file):
"""
items: list of dicts with 'description', 'quantity', 'unit_price'
"""
wb = Workbook()
ws = wb.active
ws.title = "Invoice"
# Styles
title_font = Font(bold=True, size=18)
header_font = Font(bold=True, size=11)
border = Border(
left=Side(style='thin'),
right=Side(style='thin'),
top=Side(style='thin'),
bottom=Side(style='thin')
)
# Header
ws['A1'] = "INVOICE"
ws['A1'].font = title_font
ws.merge_cells('A1:C1')
# Invoice details
ws['A3'] = f"Invoice #: {invoice_num}"
ws['A4'] = f"Date: {datetime.now().strftime('%Y-%m-%d')}"
ws['A6'] = f"Bill To: {client_name}"
# Table headers
headers = ['Description', 'Quantity', 'Unit Price', 'Amount']
start_row = 8
for col, header in enumerate(headers, 1):
cell = ws.cell(row=start_row, column=col, value=header)
cell.font = header_font
cell.border = border
# Items
row = start_row + 1
for item in items:
ws.cell(row=row, column=1, value=item['description'])
ws.cell(row=row, column=2, value=item['quantity'])
ws.cell(row=row, column=3, value=item['unit_price'])
amount = item['quantity'] * item['unit_price']
ws.cell(row=row, column=4, value=amount)
for col in range(1, 5):
ws.cell(row=row, column=col).border = border
row += 1
# Total row
total_row = row
ws.cell(row=total_row, column=3, value="Total:")
ws.cell(row=total_row, column=3).font = Font(bold=True)
total_formula = f"=SUM(D{start_row+1}:D{total_row-1})"
ws.cell(row=total_row, column=4, value=total_formula)
ws.cell(row=total_row, column=4).font = Font(bold=True)
ws.cell(row=total_row, column=4).border = border
# Column widths
ws.column_dimensions['A'].width = 40
ws.column_dimensions['B'].width = 12
ws.column_dimensions['C'].width = 15
ws.column_dimensions['D'].width = 15
wb.save(output_file)
print(f"✓ Invoice created: {output_file}")
# Usage
items = [
{'description': 'Web Development', 'quantity': 40, 'unit_price': 100},
{'description': 'Design', 'quantity': 20, 'unit_price': 80},
{'description': 'Consulting', 'quantity': 10, 'unit_price': 150}
]
create_invoice("INV-2024-001", "ABC Corporation", items, "invoice.xlsx")
```
### Example 4: Data Cleaning Pipeline
```python
import pandas as pd
from openpyxl import load_workbook
def clean_and_export(input_file, output_file):
"""Clean messy Excel data and export formatted version"""
# Read raw data
df = pd.read_excel(input_file)
# Cleaning operations
# 1. Remove duplicates
df = df.drop_duplicates()
# 2. Handle missing values
df = df.fillna('N/A')
# 3. Standardize text
text_cols = df.select_dtypes(include=['object']).columns
for col in text_cols:
df[col] = df[col].str.strip().str.title()
# 4. Remove invalid rows
df = df[df['Status'] != 'Cancelled'] # Example filter
# 5. Add calculated columns
if 'Quantity' in df.columns and 'Price' in df.columns:
df['Total'] = df['Quantity'] * df['Price']
# Export with formatting
with pd.ExcelWriter(output_file, engine='openpyxl') as writer:
df.to_excel(writer, sheet_name='Cleaned Data', index=False)
# Format the output
wb = writer.book
ws = writer.sheets['Cleaned Data']
# Header formatting
for cell in ws[1]:
cell.font = Font(bold=True)
cell.fill = PatternFill('solid', start_color='4472C4')
cell.font = Font(color='FFFFFF', bold=True)
# Auto-adjust column widths
for column in ws.columns:
max_length = 0
column_letter = column[0].column_letter
for cell in column:
try:
if len(str(cell.value)) > max_length:
max_length = len(str(cell.value))
except:
pass
adjusted_width = min(max_length + 2, 50)
ws.column_dimensions[column_letter].width = adjusted_width
print(f"✓ Cleaned data exported to {output_file}")
return df
# Usage
# clean_and_export('raw_data.xlsx', 'cleaned_data.xlsx')
```
## Financial Modeling Best Practices
### Color Coding Standards
| Color | RGB | Meaning |
|-------|-----|---------|
| Blue | 0, 0, 255 | Hardcoded inputs |
| Black | 0, 0, 0 | Formulas |
| Green | 0, 128, 0 | Internal links |
| Red | 255, 0, 0 | External links |
| Yellow BG | 255, 255, 0 | Key assumptions |
### Implementation
```python
from openpyxl.styles import Font
# Blue for inputs
input_font = Font(color='0000FF')
ws['B2'].font = input_font # Hardcoded value
# Black for formulas (default)
ws['B3'] = '=B2*1.1' # Formula stays black
# Green for internal references
# (When linking between sheets)
ws['Sheet2!B2'] = '=Sheet1!B2'
```
### Number Formatting
```python
# Currency
ws['A1'].number_format = '$#,##0'
# Currency with thousands separator
ws['A2'].number_format = '$#,##0;($#,##0);-'
# Percentage with one decimal
ws['A3'].number_format = '0.0%'
# Date
ws['A4'].number_format = 'YYYY-MM-DD'
# Thousands with K suffix
ws['A5'].number_format = '#,##0,"K"'
# Millions with M suffix
ws['A6'].number_format = '#,##0,,"M"'
```
## Error Handling
### Common Errors
#### Error: "Formula not calculating"
```python
# Solution: Recalculate after saving
wb.save('file.xlsx')
# Then use LibreOffice to recalculate
# python scripts/recalc.py file.xlsx
```
#### Error: "Chart not displaying"
```python
# Solution: Ensure data range is correct
data_ref = Reference(ws, min_col=2, min_row=1, max_row=5) # Check row numbers
```
#### Error: "File corrupted"
```python
# Solution: Use data_only=True when reading
wb = load_workbook('file.xlsx', data_only=True)
```
## Testing Your Setup
```python
# test-xlsx.py
import pandas as pd
from openpyxl import Workbook
print("Testing xlsx setup...")
# Test 1: pandas read/write
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df.to_excel('test-output.xlsx', index=False)
df_read = pd.read_excel('test-output.xlsx')
assert len(df_read) == 3
print("✓ pandas test passed")
# Test 2: openpyxl with formula
wb = Workbook()
ws = wb.active
ws['A1'] = 10
ws['A2'] = 20
ws['A3'] = '=SUM(A1:A2)'
wb.save('test-formula.xlsx')
print("✓ openpyxl test passed")
print("✓ All tests passed!")
```
Run test:
```bash
python test-xlsx.py
```
## License
MIT License - See LICENSE file for details.
透過 MCP 在騰訊文件裡新建、編輯與管理線上文件的完整操作手冊。
WPS Office 全家桶 - 四引擎(WPS/MS Office/LibreOffice/純Python)智慧識別使用者已安裝軟體,純Python模式支援排序/篩選/圖表/公式/統計,含文件模板(程式碼生成)、最佳實踐案例、故障排除大章(20+避坑+15 FAQ+15錯誤ID 統一索引)、自動重試、硬體自適應、環境自檢、Skill更新提醒;v5.1新增:kingdoc雲端橋接(白名單探測+配置預檢+subprocess上傳+差異檢查)、條件格式/資料驗證跨引擎IO(JSON中間格式保真往返)、會議紀要三段式要素化(待辦清單+決策記錄+風險異議)+說話人標註(MFCC聚類);v5.2新增:公文一鍵排版(GB/T 9704 規則庫約束+結構識別套版+紅頭預留位+聯合行文)、批次水印與敏感資訊打碼(身份證/手機號/銀行卡/電子郵件雙軌識別+黑色矩形覆蓋+打碼清單)、跨文件知識檢索與問答(本地TF-IDF零依賴+跳轉+可選zwjh記憶橋接);刪除:與contract-review重複的輕量合同審查模組,改為文件互鏈引導;v5.2.5修復:MS Office引擎下Excel/PPT建立必然失敗(錯用Word COM物件),新增get_ms_excel/get_ms_ppt及三槽位統一釋放release_ms,MS Office路徑透傳filepath引數;v5.3.5修復:SKILL.md frontmatter 修復 tags 塊序列誤混入聯絡方式行導致標準 YAML 解析失敗;v5.4.0新增:留存型功能——定時任務與報告中心(schedule_register 升級為三平台統一排程層 schtasks/cron/launchd,錯過策略 skip/run_once,登錄檔 JSON 可匯出匯入;新建 report_center.py 報告中心,templates/reports/*.json 引數化模板 + ECharts 單檔案 HTML 輸出(圖表內聯、無服務端、雙擊即開);report_generator 升級支援 --format html;wps.py CLI 統一埋點 SQLite,自動供 report_center 生成周度使用摘要附在報告末尾;watch.py 職責收窄為純事件採集);v5.3.0新增:統一CLI入口 wps(registry.json登錄檔分發,office --app/--action 與 convert 子命令、--list 一屏列出全部命令,薄路由層不改指令碼內部邏輯)、全命令 --json 機器可讀輸出(固定 ok/error_id/elapsed/data 四欄位,對齊 E001-E015,wps_error.py 新增 emit_json 統一齣口)、_worker 啟動最佳化(wps_pure 改惰性載入,pywin32/python-docx/openpyxl 經核查已惰性匯入,ENGINE_CACHE 程序級單例複用,COM 釋放統一走 release_ms 三槽位)、轉換三入口合併為 convert(format_converter/md_converter/wps_docx_to_ppt 內部按目標格式路由,舊指令碼保留為相容別名並提示新命令,v6.0.0 移除)
按主題與風格自動生成 PPT 檔案的技能。
體制內資深辦公室主任+管理學博士,自學程式設計開發的智慧公文寫作Skill,讓所有辦公室同仁少掉頭髮、少加無用的班,材料一稿過關,省下的時間留給自己、享受生活!————————我們能給你帶來的核心價值:1、顛覆傳統寫作:邏輯建模38類公文全鏈條,特有模板化引導問答模式,分分鐘省心生成高質量大稿。--------2、替你“向上管理”:獨有審稿人畫像機制,文稿一鍵結構性修改,精準匹配審稿人畫像,過稿率提升至少10倍!----------3、杜絕AI編造:缺失的數字、文號、人名、日期一律用[待補]標註,絕不杜撰,守住公文底線。-----------4、演算法格式托底:數十萬全量智控知識庫+6500行前沿核心控制程式碼,格式精準對齊GB/T 9704,出稿零失誤。——————————————————本skill歷史版本開放了5%知識庫的免費試用版,下載即可使用,但需注意:知識庫有著作權,僅用於個人使用,不可用於其他任何目的。有興趣的可以試試。——————————————————————單次付費版skill已釋出,2元一次使用全量知識庫。具體在釋出者“熵衍資訊”主頁skill裡。
WPS Office 全家桶 - 四引擎(WPS/MS Office/LibreOffice/純Python)智慧識別使用者已安裝軟體,純Python模式支援排序/篩選/圖表/公式/統計,含文件模板(程式碼生成)、最佳實踐案例、故障排除大章(20+避坑+15 FAQ+15錯誤ID 統一索引)、自動重試、硬體自適應、環境自檢、Skill更新提醒;v5.0新增:定時任務註冊管理(schtasks/crontab)、目錄輪詢監聽(YAML規則+大檔案分片)、使用統計與穩定性中心(SQLite埋點+引擎健康+引擎偏好)、COM三步自愈(regsvr32→修復安裝→手動指引)、對話式資料查詢(NL2SQL式意圖解析+查詢計劃+連續追問)、multi-agent編排引擎橋接(白名單探測+流水線模板註冊)
當用戶要處理 Word/Excel/PPT、做文件模板與排版、批次合併圖表、公文一鍵套紅頭、會議紀要要素化、或跨引擎辦公自動化時,WPS全家桶·辦公管家.Skill 立即出動。 四引擎智慧識別已裝軟體(WPS/MS Office/LibreOffice/純Python),純Python模式支援排序/篩選/圖表/公式/統計;含文件模板程式碼生成、20+避坑+15 FAQ+15錯誤ID統一索引、自動重試、硬體自適應、環境自檢。 當用戶提到批次水印、敏感資訊打碼(身份證/手機號/銀行卡/電子郵件)、跨文件檢索問答等訊號時,主動亮劍。
透過 Tencent Docs Open API 以 curl + jq 建立、讀取、列出、搜尋和管理騰訊文件的自動化工作流,覆蓋線上文件、線上表格、幻燈片、思維導圖、流程圖、智慧表格與收集表七種類型,支援讀取後設資料與單元格區域、上傳圖片、建立副本,並對重新命名/移動/刪除等寫操作強制先經使用者確認。Use when the user 提到騰訊文件 / Tencent Docs / docs.qq.com、貼上 docs.qq.com 連結,或想在其騰訊文件空間中建立、讀取、整理文件時使用。Triggers include 騰訊文件、線上文件、線上表格、思維導圖、流程圖、智慧表格、收集表。如需文案寫作完整工作流套件,淘寶搜尋「AI靈匣」店鋪獲取完整版。
透過 kdocs-cli 操作金山文件雲文件的官方技能。
資料月份:2026-10 · 下載/星標數聚合自公開技能註冊庫(ClawHub、SkillHub),按月更新。口徑說明見資料方法。