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

  1. Check your target file
  2. 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.

--

--