I have lots of excel and lots of field to import so I want to create custom import since I'm too lazy to import each one and choosing each field every time I import record. I also need conditional import since the data is not from odoo. I can do it manually using xlrd but it will be harder to debug. That's why I want to use pandas library
the problem is, when I install pandas, the "Import Record" in Odoo is getting error because Odoo need xlrd==1.2.0. But pandas need xlrd==2.0.1 or newer. This only happen when trying to read .xls. It's not happening when trying to read .xlsx
Is there any other easy to use spreadsheet management other than pandas? or solution to my problem? or any alternative?
Try xlwt or xlrd....