Readtable function on Matlab
34 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(2 个)
Image Analyst
2020-12-1
You need to add parameters, like
T = readtable('Task3.xlsx', 'Sheet', 'Sheet1', 'A1');
Read the help for readtable for special spreadsheet options.
Walter Roberson
2020-12-1
编辑:Walter Roberson
2020-12-1
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');
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!