Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Enable Column Visibility & Grouping Features in Streaming Transmission to Optimize Large File Workflows #2212

Open
@fuyilin031011-svg

Description

Description

I’m writing to share a feature request related to Excelize’s streaming transmission functionality, which is critical for our business when handling large Excel files.
First, I want to emphasize how valuable the streaming transmission feature is—it effectively solves the high memory usage issue with large files, and has been a key part of optimizing our workflows.
However, we’ve hit a practical bottleneck: two commonly used column-related features—column visibility control (addColVisible) and column grouping (addGroupColumns)—are not currently supported in streaming mode. To work around this, we have to first export the file via streaming, then reload it separately to configure column visibility or group columns. This not only adds unnecessary code complexity (needing extra post-processing logic) but also consumes additional memory—undermining the core benefit of using streaming to minimize memory footprint.
Both features are essential for business scenarios with large spreadsheets: for example, we often need to hide non-critical columns to simplify readability, or group related columns (e.g., quarterly data) for better data organization. Supporting them in streaming mode would make the workflow much more efficient.
If this improvement fits with the project’s roadmap, I’d be happy to collaborate on the development—whether it’s testing, contributing code, or discussing implementation details. Please let me know how I can help.
Thanks for your time and consideration!
Best regards

Additional context

No response

Validations

  • Check that there isn't already an issue that requests the same feature to avoid creating a duplicate.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

        AltStyle によって変換されたページ (->オリジナル) /