#849 Type Error When Loading Excel with Conditional Formatting in Pivot Table
*Created originally on Bitbucket by [qiaoruiyt (Ray)](https://bitbucket.org/%7B4dc3f263-fefa-4a96-b295-354d452ce807%7D/)* *.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.xlsx](/uploads/fa674f87112bc120456de8fbfb6314cc/Sample.xlsx)[Book2.xlsx](/uploads/5affb92e73c292ad0267b18498fb11a5/Book2.xlsx)
issue