👉 Project Website: https://www.python-office.com/ 👈

👉 Open Source Project Discussion Group 👈

github star gitee star atomgit star

AI Programming AI Discussion Group

Main Content

Python Official released python-office, a library for Python automation: Breaking! Official Released Third-Party Library: python-office, Built for Python Automation
No need to write code yourself, just call the ready-made methods.

Hello everyone, this is CoderWanFeng, focusing on sharing: Python Automation.
This series of tutorials introduces the features of python-office automation, one by one.

1. Feature Introduction

Today we introduce one of the features of this library:

Query All Excel Files for Specified Content Occurrences: Only one line of code to query and count occurrences of a specified keyword in all Excel files in a directory, and save as an Excel file.

2. Usage Instructions

Download poexcel

Only one command is needed to automatically download and install poexcel

1
pip install poexcel

Call the Function

Copy the code below, modify the file location, right-click and select Run

1
2
3
4
5
6
7
8
9
10
11
import poexcel

poexcel.query4excel(query_content='小红书',
                    query_path=r'./test_files/30-20-query4excel',
                    output_path=r'./test_files/out',
                    output_name='query4excel.xlsx')
# Parameter explanation:
# query_content: Keyword to search for
# query_path: Path where Excel files to search are located
# output_path: Output path for result file
# output_name: Name of the result file

3. Submit Requirements

Is it simple to implement complex functions with just 1 line of code? The python-office automation library is still under continuous development.
Everyone is welcome to join the discussion group to share your feature requests~

Also welcome developers with technical skills to enrich this project together:

CoderWanFeng focuses on AI programming training. Beginners can start making AI projects after watching his tutorial 《30 Lectures · AI Programming Training Camp》 collaborated with Turing Community.

🎓 AI 编程实战课程

想系统学习 AI 编程？程序员晚枫的 AI 编程实战课 帮你从零上手！