Install in seconds

Install this skill

Copy the command and run it in your terminal. You can review the source before installing.

terminal

git clone https://github.com/CoderWanFeng/python-office

Works with Git. The repository opens in your current directory.

📊

AutomationPython

Sheet2Excel

by CoderWanFeng

Splits multiple sheets of a single Excel file into separate individual Excel files. Use when you need to split an Excel workbook by sheet.

1.3K stars297 forksAdded 2026/07/20

View source on GitHub Download ZIP

officepippypipythonweixin

Documentation

README

From the original repository

sheet2excel Skill

将同一个 Excel 里的不同 sheet 拆分为不同的 Excel 文件

功能描述

将一个包含多个 sheet 的 Excel 文件，按 sheet 拆分为多个独立的 Excel 文件。

所属分类

office/skills/excel/sheet2excel/

调用方式

from office.skills.excel import sheet2excel

sheet2excel(
    file_path='./multi_sheet.xlsx',
    output_path='./output/'
)

参数说明

参数	类型	必填	默认值	说明
`file_path`	str	是	-	需要拆分的 Excel 文件路径
`output_path`	str	否	`'./'`	拆分后文件的输出目录

返回值

None

使用示例

from office.skills.excel import sheet2excel
sheet2excel(file_path='./data.xlsx', output_path='./split_output/')

视频教程

https://www.bilibili.com/video/BV1714y147Ao/

原始函数

office.api.excel.sheet2excel

More from CoderWanFeng

Other Claude Code skills by this author in the directory.

Excel to PDF

Converts a specified worksheet from an Excel file to a PDF file. Use when you need to export Excel data as a PDF document.

Fake2Excel

Automatically creates Excel files filled with mock data for testing. Supports multiple column types (name, phone, address) and Chinese/English locales.

Find Excel Data

Search for a specified keyword across all Excel files in a directory and return the matching file names, row numbers, and content details.

Merge Excel Files

Merges all Excel files in a directory into a single Excel file, with each original file becoming a separate sheet. Useful for consolidating multiple Excel workbooks.

Merge to Sheet

A Python utility that merges all sheets from multiple Excel files into a single sheet. Useful for consolidating data from various workbooks into one unified table.

Split Excel by Column

Splits an Excel file into multiple files based on the contents of a specified column, creating one file per unique value. Use when you need to split Excel data by a column field.

More Automation skills

Sheet2Excel is one of 173 Automation skills cataloged on DirSkills.

Browse all Automation skills →

2Slides Presentation Generator

Generates presentations via the 2slides API from text, reference images, or documents. Supports AI voice narration and exports to PDF and interactive slides.

Acceptance Orchestrator

Orchestrates coding tasks as a state machine that progresses from issue intake through implementation, review, and deployment, stopping only when acceptance criteria are verified with evidence or the task is escalated.

Active Directory Attacks

Comprehensive techniques for attacking Microsoft Active Directory environments, covering reconnaissance, credential harvesting, Kerberos attacks, lateral movement, privilege escalation, and domain dominance for red team operations and penetration testing.