Data Analysis from Excel File

Hello, I have written the following code in order to plot a graph from an 8760x4 excel table. The graph is between a 8760x1 row which contains time and a 8760x1 row that contains numerical values.I am attaching the code , please let me know what is the mistake as my plot function is not working.

xlsfinfo('C:\Users\sayan\OneDrive\Desktop\energytransition\Paderborn_2019_Quiz')

paderSolar=readtable('C:\Users\sayan\OneDrive\Desktop\energytransition\Paderborn_2019_Quiz');

paderSolar=table2timetable(paderSolar)

Timestamp=paderSolar(:,2)

GlobIrrad=paderSolar(:,3)

figure(1)

plot(TimeStamp,GlobIrrad)

when I run this particular code the error :

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.

and its suggesting to use stackedplot in that case I am getting the output of entire table but that is not what I need I need the graph between two columns.

any lead in these scenario will be appriciated,

thank you

regards

sayantan

[Walter Roberson]

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating

That is a warning not an error. You can ignore it because you never use the variable names.

Answer 1

[Walter Roberson]

Timestamp=paderSolar{:,2} ;
GlobIrrad=paderSolar{:,3} ;