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.

🔍

DataPython

Find Excel Data

by CoderWanFeng

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

1.3K stars297 forksAdded 2026/07/20

View source on GitHub Download ZIP

officepippypipythonweixin

Documentation

README

From the original repository

find_excel_data Skill

搜索 Excel 中指定内容的文件、行数、内容详情

功能描述

在指定目录下的所有 Excel 文件中搜索包含特定关键词的内容，并返回匹配的文件名、行号和详情。

所属分类

office/skills/excel/find_excel_data/

调用方式

from office.skills.excel import find_excel_data

find_excel_data(
    search_key='python',
    target_dir='./data'
)

参数说明

参数	类型	必填	默认值	说明
`search_key`	str	是	-	需要搜索的关键词
`target_dir`	str	是	-	搜索的目录路径

返回值

None（结果直接打印输出）

使用示例

from office.skills.excel import find_excel_data
find_excel_data(search_key='订单', target_dir='./订单数据')

视频教程

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

原始函数

office.api.excel.find_excel_data

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.

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.

Sheet2Excel

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

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 Data skills

Find Excel Data is one of 45 Data skills cataloged on DirSkills.

Browse all Data skills →

A/B Test Setup

A structured step-by-step guide for setting up valid A/B tests, enforcing hypothesis locking, statistical power, and metric definition before implementation. Use when you need a rigorous experimentation framework to avoid peeking and invalid results.

Ad Campaign Analyzer

Analyze cross-channel campaign data, quantify uncertainty, and propose evidence-labeled budget tests without overstating causality.

Analytics Tracking

Implements event tracking scripts and validates data collection for marketing analytics. Use when setting up analytics on websites or applications.