I'm trying to read in .xlsx files from the current folder and save them as .mat files to the same folder. However, the files are not being saved and I'm not sure why. Could somebody please advise me?
Also it would great if the .mat file names had the same names as the .xlsx files.
This is the code I'm using:
files = dir('*xlsx.'); for k = 1:numel(files) [num,text,raw]=xlsread(files(k).name); save(files(k).name); end
No products are associated with this question.
try ... [num,text,raw] = xlsread(files(k).name) [dummy,myName] = fileparts(files(k).name); save(myName) end
so the file extension is removed prior saving. i think you're overwriting your excel file.