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

[fuyilin031011-svg]

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.