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

Java
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,

Previous: Data cannot be converted to "POSIXlt" category in R

Next: The bizarre problem of laravel orm where condition failure.

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eb663b-483b1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eb663b-483b1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?