0

I am using pandas to read data from csv file and write into excel . I have done that one. I want to set bgcolor for last row in excel using pandas. Can anyone plz give some ideas to set color for last row.

Python Team
  • 1,143
  • 4
  • 21
  • 50

1 Answers1

0

I'm not sure if Pandas has capability to do this. However, once you save your file using Pandas, you can reload it and later change the last row color using xlsxwriter.

Refer here for how to use xlsxwriter.

meW
  • 3,832
  • 7
  • 27