How to extract cell arrays (dates) from a cell array
8 views (last 30 days)
I have a cell array which I want to make a matrix and create graphs from. I've done something similar before and it worked but since my matlab updated to the new one, I can't recreate my results and have come across the same problem in another data extraction.
Okay so this is my code:
%the following lines will read the excel tables into matlab so that they
Therm1 = readtable('Thermister data.xlsx');
%convert datafrom a table to cell and then a numeric array
thermister1 = table2cell(Therm1);
thermister2 = cell2mat(thermister1);
These issues pop up:
% Error using cell2mat (line 45)
% All contents of the input cell array must be of the same data type.
% Error in Thermisters (line 19)
% thermister2 = cell2mat (thermister1);
once my table is in a cell array it looks more like this:
I've tried making columns 2-6 a matriz seperately and it worked, but I can't get the date and time to be extracted into a matrix because each individual date is in it's own 1x1 cell array. How can I fix this issue?