MATLAB: How to import data with column headings

column headingsdata importimporting excel datatable2arrayvariable name on top row in matrix

Hello all, attached is a sample of my data. I would like to import the data as a matrix, when I do so, I lose column headings. Importing data as a table will work (see attached), however, I don't want my data to be in table form. I want my data in a matrix with top row as column headings as it is in csv sheet. Any thought would be appreciated. I tried to convert the table into array (table2array) but I lose column heading again.

Best Answer

This works for me:

[~, ~, data] = xlsread('data.csv')

What happened when you tried it?

Related Solutions

MATLAB: Add specific date time column to every table inside a cell

Easiest and fastest way to do it using a cellfun and converting them to a timetable. Here is one line to do it all:

NewCellArray = cellfun(@(x) table2timetable(x,'RowTimes',date),C2LatLon,'uni',false);

Or if you don't want a timetable just a table with a date column you can use below:

NewCellArray2 = cellfun(@(x) addvars(x,date,'Before','lon') ,C2LatLon,'uni',false);

MATLAB: How to add a column of today’s date to a table

I had to create ‘vTbl’, but this code should work regardless of what it is:

strs = char(randi([double('A') double('Z')], 5, 3));            % Create Variable
vTbl = table(strs, 'VariableNames',{'Strings'});                % Create ‘vTbl’
todayDate = datestr(now,'mm/dd/yyyy');                          % Create Date String
datesvct = repmat(todayDate, size(vTbl,1), 1);                  % Create ‘Vector’ Of Date String
vTbl = [ table(datesvct, 'VariableNames', {'VDate'})  vTbl];    % Concatenate Dates In Table

Best Answer

Related Solutions

MATLAB: Add specific date time column to every table inside a cell

MATLAB: How to add a column of today’s date to a table

Related Question