The xlsxwriter engine uses a streaming write mode that consumes less memory and writes faster when handling very large files at the scale of millions of rows.