MATLAB Answers

0

use matlab to plot fft from excel sheet

Asked by Tam Li Na on 8 Nov 2019
Latest activity Answered by KSSV
on 8 Nov 2019
Hi
how do i plot fft from excel sheet data?
here are my codes:
Fs=20;
Ts=1/Fs;
t=0:Ts:1;
T=readtable("readings.xls");
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the
VariableDescriptions property.
Set 'PreserveVariableNames' to true to use the original column headers as table variable names.
>>start=T(A2);
Unrecognized function or variable 'A2'.
>>startpoint=xlsread("readings.xls",A2);
Unrecognized function or variable 'A2'.
Can I ask how to set the starting point using datas from my excel sheet? (to plot fft)
Thanks in advance!

  0 Comments

Sign in to comment.

1 Answer

Answer by KSSV
on 8 Nov 2019

It looks like there is no variable name A2 in the table. Try using:
T.(1), T.(2) etc...or check the variablenames by printing the table or using the below line:
T.Properties.VariableNames % T is the table variable

  0 Comments

Sign in to comment.