reading .xlsx files and saving as .mat files

Hello,

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.

Thank you

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

[Alayt Abraham Issak]

I am trying to do the same thing but Im a beginner.

Where do I type my excel file so I can get the same output?

Answer 1

[RNTL]

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.