how to download zip files, unzip XLS, and load into MATLAB
4 次查看(过去 30 天)
显示 更早的评论
I am trying to access the website:
is there any matlab code that can list the filenames on the website, download & unizp, then initiate a script to read the contained XLS files into MATLAB????
any help gratefullly appreciated
0 个评论
回答(1 个)
Richard Zapor
2013-11-16
function site_read_zip
%
% place self in write directory
web='http://www.nemweb.com.au/REPORTS/CURRENT/HistDemand/';
str=urlread(web); % read page source
% cell array of file names with an extra < symbol
% this can be done better
fn=regexpi(str,'PUBLIC[A-Z_0-9]+.zip<','match');
for k=1:size(fn,2)
file=fn{k};
unzip([web file(1:end-1)]);
end
% to read csv file use dir to get fnames and csvread
end
0 个评论
另请参阅
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!