I have a large number of .xlsx files downloaded from an external database which I want to work with. It has two worksheets, the first worksheet only has some comments on the data and the second one contains the data. 

I've tried opening the excel spreadsheet using the following two options, but they both give me an error. The error disappears when I delete the first worksheet. But since I have >350 files, I don't want to delete the all those worksheets manually. 

The code I tried

```
    from openpyxl import load_workbook
    wb = load_workbook('/Users/user/Desktop/Data_14.xlsx')

```

Which gives the error: 

```
    InvalidFileException: "There is no item named 'xl/styles.xml' in the archive"

```

And:

```
    from xlrd import open_workbook
    book = open_workbook('/Users/user/Desktop/Data_14.xlsx')

```

which gives a very long error message (KeyError: 9)

I think the problem is a formula error in the first excel worksheet. One cell in the worksheet says

```
- minimum percentage that must characterise the path from a subject Company up to its Ultimate owner: 50.01%                    

```

but it is not formatted as text. Executing the cell gives an error message in Excel. Inserting an " ' " to make it text lets me then open the file with python which is what I want to do. 

Any ideas on how I can open the excel files automatically to solve this problem?