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

5 views (last 30 days)
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 Comment
Sindar
Sindar on 25 Apr 2020
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).

Sign in to comment.

Accepted Answer

per isakson
per isakson on 25 Apr 2020
Edited: per isakson on 25 Apr 2020
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 Comment
Josh Belandres
Josh Belandres on 25 Apr 2020
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.

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!