Workbook options. More...
Optional parameters when creating a new Workbook object via workbook_new_opt().
The following properties are supported:
constant_memory: Reduces the amount of data stored in memory so that large files can be written efficiently.
worksheet_write_*()functions. Therefore, once this option is active, data should be written in sequential row order. For this reason the
worksheet_merge_range()doesn't work in this mode. See also Constant Memory Mode.
tmpdir: libxlsxwriter stores workbook data in temporary files prior to assembling the final XLSX file. The temporary files are created in the system's temp directory. If the default temporary directory isn't accessible to your application, or doesn't contain enough space, you can specify an alternative location using the
Optimize the workbook to use constant memory for worksheets
Directory to use for the temporary files created by libxlsxwriter.