Jul 26, 2022
1 min read
python read excel Worksheet index 0 is invalid, 0 worksheets found
A simple solution to python — Pandas: ValueError: Worksheet index 0 is invalid, 0 worksheets found — Stack Overflow
- Check your target file
- find the sheet’s name
3. launch a new blank excel
4. find the sheet’s name
If they have a different default worksheet name, close all Excels, and regenerate the target excel. (The default worksheet name would be switched back to normal)
Now re pd.read_excel again. It’ll be successful.
Contact me: Hung, Chien-Hsiang (chienhsiang-hung.github.io)
