Skip to content

Allow Set Style by Column #397

@teschste

Description

@teschste

Currently, excelize sets the style on a cell-by-cell basis. If you have a large spreadsheet with a lot of rows, this can be tedious and take progressively longer the more rows need to be set. This can be seen if you try to set a single style on a single empty column, for all 1,048,576 rows. The more columns you attempt this for the longer this takes. While this is an extreme example, setting styles by columns is much simpler and is a common use-case in Excel.

Request that excelize support setting the style by columns (e.g. "A" or "A:A", "A:C", etc). In my own research, this is as simple as setting the style attribute on the col tag for the appropriate column(s).

Activity

added a commit that references this issue on Oct 23, 2020
45b02c7
added a commit that references this issue on Mar 14, 2024
7e77e14
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @xuri@teschste

        Issue actions

          Allow Set Style by Column · Issue #397 · qax-os/excelize