Readtable function on Matlab
34 views (last 30 days)
Show older comments
Hi I am trying to get some data from excel into matlab and when I use the:
%% Load data
T = readtable("Task3.xlsx","Sheet1","Data");
script it does not seem to work when i run that section and comes up with errors:
Error using readtable (line 198)
Unable to find or open 'Task3.xlsx'. Check the path and filename or file permissions.
Error in Task3_MatlabScript (line 4)
T = readtable("Task3.xlsx","Sheet1","Time[s]");
If anyone can point me in the right direction and explain why this is occuring that would be of such great help.
Many thanks.
0 Comments
Answers (2)
Image Analyst
on 1 Dec 2020
You need to add parameters, like
T = readtable('Task3.xlsx', 'Sheet', 'Sheet1', 'A1');
Read the help for readtable for special spreadsheet options.
Walter Roberson
on 1 Dec 2020
Edited: Walter Roberson
on 1 Dec 2020
Unable to find or open 'Task3.xlsx'
Task3.xlsx is not in your current directory, and not in any directory that is on the MATLAB path.
If it is in a different directory, you need to provide the absolute or relative path for it.
If you used something like
[filename, pathname] = uigetfile('*.xlsx', 'Choose a .xlsx file');
then you need to use
fullname = fullfile(pathname, filename);
T = readtable(fullname, 'Sheet', 'Data');
See Also
Categories
Find more on Structures 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!