File size: 265 Bytes
78f194c
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
# sheet_reader.py
import pandas as pd

def list_sheets(file_path: str):
    xls = pd.ExcelFile(file_path)
    return xls.sheet_names

def read_sheet(file_path: str, sheet_name: str) -> pd.DataFrame:
    return pd.read_excel(file_path, sheet_name=sheet_name)