Friday 29 December 2017

XLwings formatting

The code below show a couple of functions I set up for formatting in XLwings. I was regularly applying some standard colours and borders etc. so decided that the easiest way to do with was to create my own functions that I can then call from another script. I have examples of this in the code below and the sample spreadsheet can be found here. 

The code:


Using this code

2 comments:

  1. Hello,

    Very helpful article!

    I need to copy and paste soem ranges while keeping the formatting intact using python,

    Could you shed some light on this?

    Thanks,
    Kunal

    ReplyDelete
  2. How do you do these using a mac though?

    ReplyDelete