Unzip and rename excel file

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

Thank you for your help.

Answer 1

[MJFcoNaN]

the function of unzip allows setting an output folder, for example:

unzip([web file(1:end-1)], file(1:end-5))

[Tiago André]

Could i unzip to an output folder with the same name of the original zip file?

[Tiago André]

How? Could you please give and example in a script? I have never used that functions before

[MJFcoNaN]

I think the code is what you need exactly. Doesn't it work?

[Tiago André]

Yes, it worked. Thank you for your help!