What is the “useTempFile”

General
1

Hi,

What is the “useTempFile” argument in the Book.Save method?
Why does it reduce memory usage?
This setting cannot be found in Excel.exe.

Best regards,

2

Using a temporary file reduces the memory needed by LibXL.
Instead of having the XML and the compressed file in memory together, it can use a temporary file.

The resulting Excel file is the same.

And I think with 64-bit applications you will not need this flag, only for 32-bit if the Excel file is too large to fit in memory.

1 Like
3

I understand.

And I think with 64-bit applications you will not need this flag, only for 32-bit if the Excel file is too large to fit in memory.

I’ll do that.
Thank you very much.