Skip to content

Support streaming writer on existing sheets #2211

@GuchiGangz

Description

@GuchiGangz

Description

Hello 👋

Currently, NewStreamWriter in Excelize only supports creating a new sheet for streaming writes. This is very useful for large datasets because of the reduced memory usage.

However, in many real-world use cases, we need to append or modify data on an existing sheet without loading the entire workbook into memory. For example:

  • Adding new rows to an existing data sheet with headers already defined.

Currently, the old data in the Sheet will be disappear only new StreamData will be append into it

👉 Feature Request:
Enable NewStreamWriter to work on an existing sheet so we can stream data into it directly (append or write new rows) without recreating sheets.

This would make Excelize even more powerful for handling large files with pre-existing templates.

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