reading .xlsx files and saving as .mat files

2 次查看（过去 30 天）
John
John 2011-12-15
评论： Alayt Abraham Issak 2019-1-18
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
  1 个评论
Alayt Abraham Issak
Alayt Abraham Issak 2019-1-18
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?

请先登录，再进行评论。

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

回答（1 个）

RNTL
RNTL 2012-2-10
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by