How to create a zipped excel file in streaming mode?

[kumaresansv]

Hi

I am trying to create an Excel file using the streaming api. Since the resulting file is huge, I tried using the ZIP option to compress the file.

`
const options = {
filename: './test.xlsx.zip',
useStyles: false,
useSharedStrings: false,
zip: {
zlib: { level: 9 }, // Sets the compression level.
}, // Sets the compression level.
};

const workbook = new Excel.stream.xlsx.WorkbookWriter(options);
`

I am unable to get it to work and also not able to find examples on the internet. Am I doing something wrong? Has anyone gotten ZIP to work with XLSX streaming option?

Thanks for the help.

[kumaresansv]

I think I figured it out. XLSX files itself are zipped files. The compression level automatically reduces the XLSX file size. I was expecting a ZIP file to be created that contained a XLSX file inside. And my expectations were wrong.

Thanks
Kumar