python read excel Worksheet index 0 is invalid, 0 worksheets found
- 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)
pd.read_excel again. It’ll be successful.