Pandas: ValueError: Worksheet index 0 is invalid, 0 worksheets found

Question

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.

Answer 1

Your file is saved as Strict Open XML Spreadsheet (*.xlsx). Because it shares the same extension as Excel Workbook, it isn't obvious that the format is different. Open the file in Excel and Save As. If the selected option is Strict Open XML Spreadsheet (*.xlsx), change it to Excel Workbook (*.xlsx), save it and try loading it again with pandas.