Unzip and rename excel file

Question

Tiago André 2022-4-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1699240-unzip-and-rename-excel-file

评论： Tiago André 2022-4-19

Hey, hope you doing well.

I have this code that goes to a website database, downloads and unzips all the files there. Each zip file comes with hundreds of txt files and two excel files. I only need the two excel files, however its not a problem if the code downloads the txt files aswell. The problem is that the excel files have all the same name, so when i run the code i get in the folder thousands of text files and only two excel files. The code is overwriting the excel files when unziping.

How can i make matlab, after unziping, to change the name of the excel files so they wont overwrite?

This is the script i have.

web ='https://sensors.rivm.nl/benchmark/';
data = webread(web); 
files = regexpi(data,'[A-Z_0-9]+.zip<','match');
for k=1:numel(files)
    file = files{k} ;
    unzip([web file(1:end-1)])
end