Problem of getting XLS file data into python

[klllmmm]

  May.XLS (Size: 50.75 KB / Downloads: 206)
  Apr.XLS (Size: 54.54 KB / Downloads: 199)
I'm trying to get the data from 2 XLS files into python. These XLS files were exported files from SAP system.

However i can't get the data into python.

https://drive.google.com/open?id=0B6D2lP...UlYdHFMdHM

https://drive.google.com/open?id=0B6D2lP...0VoR054a1k

Method 1

import glob
import pandas as pd

path = "C:/Users/Desktop/MJ"
file_identifier = "*.XLS"

all_data = pd.DataFrame()
for f in glob.glob(path + "/*" + file_identifier):
    df = pd.read_excel(f)
    all_data = all_data.append(df,ignore_index=True)

No data comes to python variable all_data

Method 2
Also i tried through xlrd

import xlrd

workbook = xlrd.open_workbook('C:/Users/Desktop/MJ/Apr.xls')

Error:
Traceback (most recent call last):

  File "<ipython-input-14-9f59ece120e8>", line 2, in <module>
    workbook = xlrd.open_workbook('C:/Users/Gishan/Desktop/MJ/Apr.xls')

  File "C:\Program Files\Anaconda3\lib\site-packages\xlrd\__init__.py", line 395, in open_workbook
    with open(filename, "rb") as f:

FileNotFoundError: [Errno 2] No such file or directory: 'C:/Users/Gishan/Desktop/MJ/Apr.xls'

Can someone help me to solve this.