As title, I now have two payroll, one is the last month, this month is a, table format is excel, I want to achieve by matching the id number, then find out the same person in two payroll last month and this month's different cell, the red, because have personnel in and out of the last month and this month, so if the person id card match is less than is selling the red, consult prawns, how to achieve the above functions,

CodePudding user response:

Read the id number of the list last month, matching of this month, you won't find, set the line style into red, with pandas openpyx can

CodePudding user response:

If id just find the different, this I still will, is the first main problem: by matching the id number, then find out the same person in two payroll last month and this month's pay a different cell, the red, this does not,

CodePudding user response:

To put it bluntly, you just want to give what is inside the cell on a color?
Using XLWT module to write excel document can be styled!
Study of how to use XLWT. Easyxf () styled basic can solve your problem!

CodePudding user response:

https://editor.csdn.net/md/? ArticleId=104909170,

CodePudding user response:

https://blog.csdn.net/weixin_45903952/article/details/104909170
Look at this style