TypeError: __init__() got an unexpected keyword argument 'mergeCell'
Created originally on Bitbucket by Fakhrul Khan (Fakhrul Hasan Khan)
I am getting this issue when i can trying to open a workbook Workbook has multiple worksheet with lots of data in it.
Code: import xlrd import sys import os import pandas as pd from openpyxl import Workbook from openpyxl.compat import range from openpyxl.cell import get_column_letter from openpyxl import load_workbook
print 'Python version ' + sys.version print 'Pandas version: ' + pd.version
b=r'C:\Python34\dashborad_excel\fx7500_report.xlsx' a="fx7500_report.xlsx" path = os.path.abspath(file).rstrip(file)+a print path wb=load_workbook(filename=path, read_only=True) ws=wb('Execution Plan')
I get below error:
C:\Python27\python.exe C:/Python34/dashborad_excel/plot2.py Python version 2.7.10 (default, May 23 2015, 09:40:32) [MSC v.1500 32 bit (Intel)] Pandas version: 0.16.2 C:\Python34\dashborad_excel\fx7500_report.xlsx C:\Python34\dashborad_excel\fx7500_report.xlsx Traceback (most recent call last): File "C:/Python34/dashborad_excel/plot2.py", line 25, in wb=load_workbook(filename=path, read_only=True) File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 149, in load_workbook _load_workbook(wb, archive, filename, read_only, keep_vba) File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 204, in load_workbook parsed_styles = read_style_table(archive) File "C:\Python27\lib\site-packages\openpyxl\reader\style.py", line 203, in ead_style_table p.parse() File "C:\Python27\lib\site-packages\openpyxl\reader\style.py", line 55, in parse self.parse_dxfs() File "C:\Python27\lib\site-packages\openpyxl\reader\style.py", line 81, in parse_dxfs self.cond_styles.append(DifferentialStyle.from_tree(node)) File "C:\Python27\lib\site-packages\openpyxl\descriptors\serialisable.py", line 43, in rom_tree obj = desc.expected_type.from_tree(el) File "C:\Python27\lib\site-packages\openpyxl\descriptors\serialisable.py", line 52, in rom_tree return cls(**attrib) TypeError: init() got an unexpected keyword argument 'mergeCell'
Process finished with exit code 1
Attachments: fx7500_report.xlsx