What does "Stream XLSX data" checkbox do in Microsoft Excel Writer?

[snehal]

Hi everyone,

I’m using the Microsoft Excel Writer tool and noticed a checkbox option called “Stream XLSX data.”

I’d like to understand what exactly happens when this option is enabled:

• How does it affect data writing performance?

• Are there any limitations or scenarios where it should or shouldn’t be used?

I couldn’t find a clear explanation in the documentation, so any insights or examples would be really helpful.

[AETrainings]

The “Stream XLSX data” option in the Microsoft Excel Writer plugin in AutomationEdge is used to optimize writing large datasets into Excel files.
Data is written to the Excel file in a streaming (row-by-row) manner instead of loading everything into memory first.

1. It uses less memory and prevents out-of-memory issues.
2. Improves performance when dealing with large volumes of data (thousands/millions of rows).