I am trying to export sensor data with its associated date and time to excel sheet but due to some reason the date is not getting displayed in excel sheet or in workspace. code:
filename='xbee1.xlsx';
d{1,1}='Date';
d{1,2}='Sensor Data';
c=clock;
c=round(c);
t = datetime(c(1),c(2),c(3));
data_sensor{1,1}=t;
data_sensor{1,2}=rand;
d=[d; data_sensor];
disp(d);
%xlRange = sprintf('A%i:G%i',j,k);
xlRange = 'A1';
xlswrite(filename,d,1,xlRange);
Thanks in advance..
Best Answer