#849 Type Error When Loading Excel with Conditional Formatting in Pivot Table
Created originally on Bitbucket by qiaoruiyt (Ray)
*.xlsx file cannot be loaded when there are conditional formatting in pivot table. My code is simple as :
wb_main = load_workbook('Book2.xlsx')
with error:
raise TypeError('expected ' + str(self.expected_type))
TypeError: expected <type 'basestring'>
It can only be loaded when read_only mode is True. However I might need to append data to the file. Please help!
Attachments: Sample.xlsxBook2.xlsx