Readtable function on Matlab
45 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (2)
Image Analyst
il 1 Dic 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
il 1 Dic 2020
Modificato: Walter Roberson
il 1 Dic 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');
Vedere anche
Categorie
Scopri di più su Structures in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!