Java export package (there are excel files and multiple pictures in the package)

recently received a requirement. After exporting pictures and thinking about excel, we intend to use the method of generating excel and downloading images from the server into the export provided by the compressed package for users. However, since we have not done the export of the compressed package, there are some places that do not know how to do it. Let"s talk about the current way of thinking. I hope you Daniel can point out or have a similar demo for little girls to refer to
Q1: the first step is to export excel to the specified folder on the server?
Q2: the second step is to download the image url from the database to the folder specified by the server (in the same folder as excel)?
Q3: triggers the browser to save the pop-up window, and the user saves to the specified path

Mar.30,2021

the first two steps are fine, and then before downloading, you need to compress multiple files into a zip package, and then download the package file to the foreground.

if the compressed file is very large, a better way is to download the compressed file stream directly to the foreground in the process of compression, so that you can generally compress while downloading, but the code is more difficult to achieve, if the compressed file is very large, the waiting time for clicking to start downloading is too long, you can optimize it in this way.


api,

Menu