.xlsm spread sheet returns errors
*Created originally on Bitbucket by [sumantw (S R)](https://bitbucket.org/%7B1e480e58-2692-41bd-9466-30dea1532904%7D/)* I have a complex excel spreadsheet and I have the following python script ``` #!python w = px.load_workbook('file1.xlsm', data_only=True) p = w.get_sheet_by_name(name = 'forecasting') a = p.cell('J11').value b = p.cell('J12').value print a print b ``` and when it runs it throws up the following error ``` #!python Traceback (most recent call last): File "Test2.py", line 5, in <module> w = px.load_workbook('file1.xlsm', data_only=True) File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 152, in load_workbook raise InvalidFileException(unicode(e)) openpyxl.utils.exceptions.InvalidFileException: '' ``` If it is of any help. the file throws up the following error when i use xlrd ``` #!python Traceback (most recent call last): File "Test1.py", line 5, in <module> book = xlrd.open_workbook("file1.xlsm") File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 422, in open_workbook ragged_rows=ragged_rows, File "C:\Python27\lib\site-packages\xlrd\xlsx.py", line 765, in open_workbook_2007_xml x12book.process_stream(zflo, 'Workbook') File "C:\Python27\lib\site-packages\xlrd\xlsx.py", line 254, in process_stream meth(self, elem) File "C:\Python27\lib\site-packages\xlrd\xlsx.py", line 359, in do_sheet reltype = self.relid2reltype[rid] KeyError: '' ``` Can you please let me know how to solve the issue?
issue