Generating an excel file from a timetable

I am trying to generate an excel file from a timetable. The timetable is an array of 2 columns, 1 contains the date and the other column data. I used this code: filename2 = 'daily'; xlswrite(filename2,temp_Hourly,'A1')

I am getting this error: Input data must be a numeric, cell, or logical array. can someone help please?

[madhan ravi]

Datas??

[Ayman Fathy]

My final result in the code is a timetable generated from the timetable function. It contains 2 columns, 1 is the date and the other is temperature data. Is there a way to export this timetable into excel?

Answer 1

[KSSV]

Read about writetable

% generate some dates 
t1 = datetime(2018,10,1,0,0,0);
t2 = datetime(2018,10,20,0,0,0);
time = (t1:t2)' ;
% some random temperatures 
Temperature = rand(size(time)) ;
% write table to excel  
T = table(time,Temperature) ;
writetable(T,'test.xlsx')

[Guillaume]

Yes, the function to write tables/timetables to a file (excel or text) is writetable, not xlswrite.

In fact, forget xlsread and xlswrite. They've both been superseded by readtable and writetable respectively, which are a lot more powerful.