jupyter_notebooks icon indicating copy to clipboard operation
jupyter_notebooks copied to clipboard

xlwings code for formatting cells

Open alphaCTzo7G opened this issue 7 years ago • 0 comments

Thanks for sharing your jupyter notebook for xlwings formatting.. very helpful..

I noticed this code here:

for cell in Range('A1').current_region:
    for border_id in range(7,12):
        cell.api.Borders(border_id).LineStyle = 1
        cell.api.Borders(border_id).Weight = 2

Do you need current region? Maybe its better to put just Range('A1:D1'), as people might be just putting in the cell numbers in Range...

alphaCTzo7G avatar Dec 31 '17 23:12 alphaCTzo7G