How to export .xls dynamically generated in .zip?

Oct 17, 2016 at 9:59 AM
Hi, first of all I apologize if the topic has already been dealt, but I could not find the solution despite having read various posts.

My application (> VB) generates an .xls file to Datatable, using NPOI library.

I wish that the xls file generated is released in .zip instead of .xls

I did several tests with DotNetZip and it works if the file takes him from a directori that I point Server.MapPath.

But I would like to get the xls file generated by NPOI directly in .zip

How can I do?