[FIXED] Pandas: ValueError: Worksheet index 0 is invalid, 0 worksheets found

Issue

Simple problem that has me completely dumbfounded. I am trying to read an Excel document with pandas but I am stuck with this error:

ValueError: Worksheet index 0 is invalid, 0 worksheets found

My code snippet works well for all but one Excel document linked below. Is this an issue with my Excel document (which definitely has sheets when I open it in Excel) or am I missing something completely obvious?

Excel Document

EDIT - Forgot the code. It is quite simply:

import pandas as pd
df = pd.read_excel(FOLDER + 'omx30.xlsx')

FOLDER Is the absolute path to the folder in which the file is located.

Solution

It seems there indeed is a problem with my excel file. We have not been able to figure out what though. For now the path of least resistance is simply saving as a .csv in excel and using pd.read_csv to read this instead.

Answered By - Ivar Eriksson