I am trying to use the information already created in an Excel document to create a Plot. The location is taken directly from the properties of the Excel file but I keep getting this error. I have been trying for a while to figure this out with no luck. Any ideas what could be wrong?

1 Commento

Rik
Rik il 18 Set 2018
What does exist return for this string?

Accedi per commentare.

 Risposta accettata

OCDER
OCDER il 18 Set 2018
Modificato: OCDER il 18 Set 2018
Does that directory exist?
C:\Users\Anthony\Desktop\220 Lab\Intro
To check
exist('C:\Users\Anthony\Desktop\220 Lab\Intro', 'dir')
If it returns 0, that directory does not exist. You cannot change to a directory that does not exist.
Also, usage of cd change directory should be minimized, as that really is just for you to use to navigate folder while coding - not to be used in actual programming runs, unless your program is specifically designed to change user folders.
Based on what you want to do, try this:
%Let's you choose the file
[FileName, FilePath] = uigetfile('Intro.xls*', 'Open Excel file.');
if isnumeric(FileName)
error('No file was selected');
end
%Or you could just start here, but define
%FilePath = 'C:\Users\Anthony\Desktop\220 Lab\Intro'
%FileName = 'Intro.xlsx'
FullFileName = fullfile(FilePath, FileName); %assemble full file path + name
Data = xlsread(FullFileName, 1, 'A2:A16'); %DO NOT do "load = " to replace load
%load is built-in matlab function!
Def = xlsread(FullFileName, 1, 'B2:B16');
plot(Data, Def) %lowercase plot, not "Plot"

4 Commenti

Anthony Voccia
Anthony Voccia il 18 Set 2018
Thanks! I was going off what the TA wrote in lab. Just need to clean up the labels and this will be good to go
Make sure your xlsread actually takes the full file name as input.
xlsread('Intro', ...) ==> xlsread(fullfile(FilePath, FileName), ...)
Would that look like
data = xlsread(fullfile('C:\Users\Anthony\Desktop\220 Lab\Intro', 'Intro.xlsx'),('Intro',1,'A2:A16'))
FilePath = 'C:\Users\Anthony\Desktop\220 Lab\Intro'
FileName = 'Intro.xlsx'
FullFileName = fullfile(FilePath, FileName);
Data = xlsread(FullFileName, 1, 'A2:A16');

Accedi per commentare.

Più risposte (0)

Categorie

Richiesto:

il 18 Set 2018

Commentato:

il 20 Set 2018

Community Treasure Hunt

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

Start Hunting!

Translated by