Xlsx

作者 bobmatnyc718070a7d622無授權條款77 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫2 個月前更新

Working with Excel files programmatically.

僅含說明Documents & Office

AI 產生的概覽

提供使用 Python 與 JavaScript 函式庫讀取、寫入、格式化及轉換 Excel XLSX 檔案的參考說明。

功能: 提供以程式化方式處理 Excel 試算表的程式碼模式，涵蓋儲存格與列的讀寫、表頭樣式與數字格式設定、公式加入，以及 CSV 與 XLSX 之間的轉換。內容同時展示 Python 的 openpyxl 與 pandas 用法，以及 JavaScript 的 xlsx 函式庫用法，並包含合併多個活頁簿、資料樞紐等操作。產出的是指引說明與程式碼片段，而非可直接執行的工具。
適用情境: 適用於代理需要建立、編輯、格式化或擷取 Excel 活頁簿資料，或在試算表與 CSV 之間轉換的情境。也適用於合併多個 Excel 檔案，或套用公式與儲存格格式的情況。
執行需求: 執行 Python 範例需要安裝 openpyxl 與 pandas 的 Python 環境；執行 JavaScript 範例需要包含 xlsx 套件的 JavaScript 環境。此技能未附帶指令碼，僅包含說明與程式碼範例。

Excel/XLSX Manipulation

Working with Excel files programmatically.

Python (openpyxl)

Reading Excel

python

from openpyxl import load_workbook
wb = load_workbook('data.xlsx')ws = wb.active  # Get active sheet
# Read cellvalue = ws['A1'].value
# Iterate rowsfor row in ws.iter_rows(min_row=2, values_only=True):    print(row)

from openpyxl import load_workbook
wb = load_workbook('data.xlsx')ws = wb.active  # Get active sheet
# Read cellvalue = ws['A1'].value
# Iterate rowsfor row in ws.iter_rows(min_row=2, values_only=True):    print(row)

Writing Excel

python

from openpyxl import Workbook
wb = Workbook()ws = wb.activews.title = "Data"
# Write dataws['A1'] = 'Name'ws['B1'] = 'Age'ws.append(['John', 30])ws.append(['Jane', 25])
wb.save('output.xlsx')

from openpyxl import Workbook
wb = Workbook()ws = wb.activews.title = "Data"
# Write dataws['A1'] = 'Name'ws['B1'] = 'Age'ws.append(['John', 30])ws.append(['Jane', 25])
wb.save('output.xlsx')

Formatting

python

from openpyxl.styles import Font, PatternFill
# Bold headerws['A1'].font = Font(bold=True)
# Background colorws['A1'].fill = PatternFill(start_color="FFFF00", fill_type="solid")
# Number formatws['B2'].number_format = '0.00'  # Two decimals

from openpyxl.styles import Font, PatternFill
# Bold headerws['A1'].font = Font(bold=True)
# Background colorws['A1'].fill = PatternFill(start_color="FFFF00", fill_type="solid")
# Number formatws['B2'].number_format = '0.00'  # Two decimals

Formulas

Python (pandas)

Reading Excel

python

import pandas as pd
# Read sheetdf = pd.read_excel('data.xlsx', sheet_name='Sheet1')
# Read multiple sheetsdfs = pd.read_excel('data.xlsx', sheet_name=None)

import pandas as pd
# Read sheetdf = pd.read_excel('data.xlsx', sheet_name='Sheet1')
# Read multiple sheetsdfs = pd.read_excel('data.xlsx', sheet_name=None)

Writing Excel

python

# Write DataFramedf.to_excel('output.xlsx', index=False)
# Multiple sheetswith pd.ExcelWriter('output.xlsx') as writer:    df1.to_excel(writer, sheet_name='Sheet1')    df2.to_excel(writer, sheet_name='Sheet2')

# Write DataFramedf.to_excel('output.xlsx', index=False)
# Multiple sheetswith pd.ExcelWriter('output.xlsx') as writer:    df1.to_excel(writer, sheet_name='Sheet1')    df2.to_excel(writer, sheet_name='Sheet2')

Data Transformation

python

# Filterfiltered = df[df['Age'] > 25]
# Group bygrouped = df.groupby('Department')['Salary'].mean()
# Pivotpivot = df.pivot_table(values='Sales', index='Region', columns='Product')

# Filterfiltered = df[df['Age'] > 25]
# Group bygrouped = df.groupby('Department')['Salary'].mean()
# Pivotpivot = df.pivot_table(values='Sales', index='Region', columns='Product')

JavaScript (xlsx)

javascript

import XLSX from 'xlsx';
// Read fileconst workbook = XLSX.readFile('data.xlsx');const sheetName = workbook.SheetNames[0];const worksheet = workbook.Sheets[sheetName];
// Convert to JSONconst data = XLSX.utils.sheet_to_json(worksheet);
// Write fileconst newWorksheet = XLSX.utils.json_to_sheet(data);const newWorkbook = XLSX.utils.book_new();XLSX.utils.book_append_sheet(newWorkbook, newWorksheet, 'Data');XLSX.writeFile(newWorkbook, 'output.xlsx');

import XLSX from 'xlsx';
// Read fileconst workbook = XLSX.readFile('data.xlsx');const sheetName = workbook.SheetNames[0];const worksheet = workbook.Sheets[sheetName];
// Convert to JSONconst data = XLSX.utils.sheet_to_json(worksheet);
// Write fileconst newWorksheet = XLSX.utils.json_to_sheet(data);const newWorkbook = XLSX.utils.book_new();XLSX.utils.book_append_sheet(newWorkbook, newWorksheet, 'Data');XLSX.writeFile(newWorkbook, 'output.xlsx');

Common Operations

CSV to Excel

Excel to CSV

Merging Excel Files

python

dfs = []for file in ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']:    df = pd.read_excel(file)    dfs.append(df)
combined = pd.concat(dfs, ignore_index=True)combined.to_excel('merged.xlsx', index=False)

dfs = []for file in ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']:    df = pd.read_excel(file)    dfs.append(df)
combined = pd.concat(dfs, ignore_index=True)combined.to_excel('merged.xlsx', index=False)

Remember

Close workbooks after use
Handle large files in chunks
Validate data before writing
Use pandas for data analysis, openpyxl for formatting

來源與署名

來源：bobmatnyc/claude-mpm-skills位於universal/data/xlsx提交718070a

授權條款：無授權條款

內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。

檢舉或申請下架

Xlsx

Excel/XLSX Manipulation

Python (openpyxl)

Reading Excel

Writing Excel

Formatting

Formulas

Python (pandas)

Reading Excel

Writing Excel

Data Transformation

JavaScript (xlsx)

Common Operations

CSV to Excel

Excel to CSV

Merging Excel Files

Remember

來源與署名

更多來自 bobmatnyc/claude-mpm-skills 的技能

Wordpress Security Validation

Bug Fix

Threat Modeling

Webapp Testing

Opentelemetry

Skill Creator

更多Documents & Office技能

Process Letter

Teaser

Clean Data Xls

Datapack Builder

Cim Builder

Ppt Template Creator