How to Read Specific Excel Sheets in Python Using Pandas

1. Introduction

Hello, I'm PiPi. Recently a question about Python automation office was asked in a group, and I share the solution here.

2. Implementation

Several contributors suggested solutions. Below is one method using pandas to read specific sheets from an Excel file.

file = 'test.xlsx'
xlsx_file = pd.ExcelFile(file)
sheet_names = [sheet for sheet in xlsx_file.sheet_names if '汇总' in sheet]
dfs = pd.read_excel(file, sheet_name=sheet_names)

Another approach is to read the Excel file directly and extract the desired sheet names from df.keys(). The following code demonstrates this method.

Reading Excel files with pandas involves many nuances, as illustrated in the diagram below.

If you already know the sheet name, you can pass it directly to read a specific sheet.

3. Summary

This article addresses the basic problem of merging tables in Python automation office, providing detailed analysis and code examples to help readers solve the issue.

Tip: When asking questions in a group, consider sharing a small demo file (after data desensitization), the relevant code, and error screenshots. If the code is short, paste it directly; for longer code, attach a .py file.