Saving column headers to vector

39 次查看（过去 30 天）
Amanda Eriksson
Amanda Eriksson 2022-2-1
评论： Simon Chan 2022-2-1
I have a xlsx file which contains a set of rows and columns (26x13) but the set of columns may vary. So for each column there is a header in the xlsx, and I uses readtable to open the xlsx.
I have now divided so I get the data out from each column, but how do I save the header name? I want to be able to save the header name into some sort of string/vector so that when displaying the data it simply can be refered to that header(set of data).
files.path = '.'; % Absolute/relative path to where the selected file exist
[filename path] = uigetfile([files.path '*.txt; *.TAC; *.xlsx;'], 'Choose TAC file of .xlxs format');
t = readtable(filename,'VariableNamingRule','preserve');
A = table2array(t);
num = cellfun(@str2num,A);
[numrows, numcol] = size(num);
for i = 1:numcol
roi.names{i} = t{}; % Here I want to loop over the column headers and save down the header name into a string/vector
end

请先登录，再回答此问题。

采纳的回答

Simon Chan
Simon Chan 2022-2-1
You may retrieve the header name in a cell array as follows:
t.Properties.VariableNames
  2 个评论
Amanda Eriksson
Amanda Eriksson 2022-2-1
THANK YOU. so so much, thank you :))))
Simon Chan
Simon Chan 2022-2-1
You may accept the answer if you find it useful. Thank you.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by