MATLAB: Convert Columns Arrays to numeric

Question

Hi,

I have a timetable with various data columns – I have imported these from an excel file. I need to make an addition to the all rows of colums and to add a column with the result. I think that my arrays are currently not numeric type and therefor I can not add them. Is there a way that I can convert data of columns 1-7 to numeric and make a summation? Or how can I know the data type of the columns?

Answer 1

...how can I know the data type of the columns?

varfun(@class,combine)

solution:

load('data.mat')
combine = [combine,rowfun(@funsum,combine,'OutputVariableName','SUM_ALL_kW')];
function out = funsum(varargin)
    out = sum([varargin{:}],2);
end

or

combine.SUM_ALL_kW = sum(combine{:,:},2) ;