Skip to content

xlwings code for formatting cells #1

@alphaCTzo7G

Description

@alphaCTzo7G

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...

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions