Error in readtable function.

I was given a .csv file of data and exported it to a .xlsx file to my desktop. My matlab code now will not read the table and i am unsure why. I have attached the file to this question as well. i had run into an issue earlier where if i had the same file open more than once the code would not run. I closed everything and started matlab back up and this code will still not run. Im sure this is probably an easy fix as this is my second week using matlab and I am still learning the ins and outs. Thanbk You!

my code is as follows:

Y2 = readtable('1hz000.xlsx','Range','E1:AJ12');
oneHZ = table2array(Y2);
two = detrend(oneHZ);
for i=1:32
[pks] = findpeaks(one(:,i));
meanWH(i) = mean(pks);
end
mn1 = mean(meanWH); 
WH2 = mn1*2     

[GOPIKA]

Error in realtime_data (line 3)

data = readtable(realtime_data,'A1:BJ68'); % Using readtable for modern MATLAB versions

[Cris LaPierre]

Please share the entire error message (all the red text) along with the value of your variable realtime_data.

[Walter Roberson]

@GOPIKA

You named your function or script realtime_data the same as a variable within the function or script. That would lead to MATLAB attempting to call the script or function itself at that point, which is likely to fail.

You need to avoid naming your function or script the same as a variable you use in the function or script.

Answer 1

[Cris LaPierre]

readtable appears to be working just fine.

There are, however, some errors with your code.

• There are only 7 rows of data, yet you read in 12. The extra rows will be filled with NaN.
• The variable one does not exit. This causes an error for me.

Have you gone through MATLAB Onramp yet? Ch 11 covers importing data.

[John Carroll]

I have not. I will deffintily go through that thank you very much.

I am still reciving the folllowing error:

Error using readtable (line 245)

Unable to find or open '1hz000.xlsx'. Check the path and filename or file permissions.

Error in lab2 (line 6)

Y2 = readtable('1hz000.xlsx','Range','E1:AJ7');

I will be sure to go through MATLAB onramp thank you again!

[Cris LaPierre]

Is the file located in your current folder in MATLAB? If not, you must include the full path to the file in the filename (or add the folder containing the file to your MATLAB path).

Add Ch 3 to the chapters I recommend you go through in Onramp.

[John Carroll]

Awesome much appreciated! Got it!