Converting multiples excel files to .mat

Question

Ibro Tutic 2015-10-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/246294-converting-multiples-excel-files-to-mat

评论： Ibro Tutic 2015-10-6

Hi all, I need to convert multiple xlsx files to .mat. The directory contains 4 folders which contain about 200 folders each which contain about 4 excel files each. How can I get MatLab to go this directory and convert every .xlsx file to .mat? I know how to do it for one file, but that doesn't help very much when I have to do it for almost a thousand files.

So far I have this:

files = dir('*.csv');
for file = files'
  csv = csvread(file.name);
  % Do some stuff
end

Now I need it to read every .csv file and save the data as .mat. Would this something like this work?

files = dir('*.csv');
for file = files'
  csv = csvread(file.name);
  save = (file.name);
end

Will this go through every folder in the directory and create .mat copies of the .csv data?

Any help appreciated.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2015-10-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/246294-converting-multiples-excel-files-to-mat#answer_194367

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

8 个评论
显示 6更早的评论隐藏 6更早的评论

Walter Roberson 2015-10-1

在 MATLAB Online 中打开

The FAQ are not intended to be code to cover all possibilities: they are intended to be code showing you techniques that you can apply.

Using only the techniques shown in the FAQ, together with fileparts(), you can create this:

projectdir = '.';    %Start here. or name an absolute directory
folderinfo = dir(projectdir);
folderinfo = folderinfo([folderinfo.isdir]);  %select only the directories
folderinfo = folderinfo(~ismember({folderinfo.name}, {'.', '..'}));  %remove directories . and ..
for folderidx = 1 : length(folderinfo)
  thisfolder = fullfile(projectdir, folderinfo(folderidx).name);
  subfolderinfo = dir(thisfolder);
  subfolderinfo = subfolderinfo([subfolderinfo.isdir]);  %select only the directories
  subfolderinfo = subfolderinfo(~ismember({subfolderinfo.name}, {'.', '..}));   %remove directories . and ..
  for subfolderidx = 1 : length(subfolderinfo)
    thissubfolder = fullfile(thisfolder, subfolderinfo(subfolderidx).name);
    fileinfo = dir( fullfile(thissubfolder, '*.csv') );
    for fileidx = 1 : length(fileinfo)
      thisfile = fullfile(thissubfolder, fileinfo(fileidx).name);
        [filepath, basename, ext] = fileparts(thisfile);
        outputfile = fullfile(filepath, [basename '.mat']);
        SaveVariableNameGoesHere = csvread(thisfile);  %or as appropriate to read file
        save(outputfile, 'SaveVariableNameGoesHere');  %save as .mat
      end   %files within subfolder
    end     %subfolders with folder
  end       %folders

Ibro Tutic 2015-10-6

Thanks for all the help. One more question, how would I modify where I want the files saved? I would like to put them in a separate folder labeled with a time stamp so I know when all the files were converted, so when I do future conversions, I know what data is the most up to date. Again, thanks a ton.

Ibro Tutic 2015-10-6

Also, the CSV files I am reading contain text, so cvsread will not work. I am trying to implement textscan, but I am having troubles with how to set up the inputs. textscan(file,'?'). I noticed people using %f, %d, delimiter and stuff like that but I am not sure how to utilize these things to have it scan the .csv files correctly.

请先登录，再进行评论。