Readtable function on Matlab

45 visualizzazioni (ultimi 30 giorni)
Alfin Kunjumon Joseph
Alfin Kunjumon Joseph il 1 Dic 2020
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.

Risposte (2)

Image Analyst
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.
  1 Commento
Alfin Kunjumon Joseph
Alfin Kunjumon Joseph il 1 Dic 2020
Hi thank you for your response, I have tried that too and it still is not working I have looked at the help option on Mathworks and when I try that it does not work for some reason. I have tried to run this a million times haha and it still is not working so frustrating.

Accedi per commentare.


Walter Roberson
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');

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!

Translated by