How to load Excel .xlsx and .mat files into Matlab?

Question

Josh Belandres 2020-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/520563-how-to-load-excel-xlsx-and-mat-files-into-matlab

评论： Josh Belandres 2020-4-25

I was able to import a .xlsx file and a .mat file containing data that I need to use for my code. However when I use "load FileName" I get an error that says "unable to read file. No such file or directory." Please let me know how to do this.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sindar 2020-4-25

Are you in the same folder as the file? Have you double-checked the spelling and extension (I can't tell you how many times I've been just slightly off).

请先登录，再进行评论。

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

Answer 1

per isakson 2020-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/520563-how-to-load-excel-xlsx-and-mat-files-into-matlab#answer_428280

编辑：per isakson 2020-4-25

在 MATLAB Online 中打开

The function, load(), cannot read excel-files.

"when I use "load FileName" I get an error" FileName is that the name of a mat-file? Or is FileName the name of a variable, the value of which is the name of a mat-file?

If FileName is the the name of a mat-file

load FileName

should work

If FileName is the name of a variable, the value of which is the name of a mat-file

load( FileName )

should work

See load()

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Josh Belandres 2020-4-25

Yes, I needed to use the load() function when reading mat. file and the xlsread function when reading excel files.

However to fix the errors I put my downloaded data into a new folder within the matlab folder, restarted matlab and then was able to load the data from the workspace.

请先登录，再进行评论。