using spreadsheet column headers as variable

39 次查看（过去 30 天）

Forrest Ward 2020-5-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/528363-using-spreadsheet-column-headers-as-variable

评论： Forrest Ward 2020-5-22

I am writing a function to import an Excel table. I am using 'opts' commands in order to add some versatility to the function. However, when I use readtable(... , opts),the variables for my imported table say 'Var1, Var2, Var3..'. I want my variable names to be the variables contained in the first row of my spreadsheet. How am I able to fix this? Obviously, I don't want to use opts.'VariableNames' and type out each variable that I have. That would take way too long.

P.S. this does not happen when I use juse readtable(..), it only occurs when I have the opts with it.

2 个评论
显示无隐藏无

Sai Gudlur 2020-5-20

Try this or maybe you sharing your code might give a little more information.

[filename,pathname] = uigetfile('*.xlsx');

fullfilename = fullfile(pathname,filename);

A = importdata(fullfilename);

headers = A.textdata(1,end);

Forrest Ward 2020-5-20

在 MATLAB Online 中打开

I'll try that! And here is what my code currently looks like.

function DataTable = ReadDataTable(filename)
opts = spreadsheetImportOptions('NumVariables',6,'PreserveVariableNames',true);
opts = setvaropts(opts,'FillValue','0');
DataTable = readtable(filename,opts,'ReadRowNames',true);
end

请先登录，再进行评论。

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

采纳的回答

Cris LaPierre 2020-5-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/528363-using-spreadsheet-column-headers-as-variable#answer_434898

在 MATLAB Online 中打开

To read the tabular data while preserving variable names, set the 'PreserveVariableNames' parameter to true.

T_preserve = readtable('sampletable.txt','PreserveVariableNames',true)

You must be using MATLAB R2019b or newer to use this.

If you are using opts, try this.

opts = detectImportOptions;
...
opts.ReadVariableNames = true;
opts.PreserveVariableNames=true;
T_preserve = readtable('sampletable.txt',opts);

17 个评论
显示 15更早的评论隐藏 15更早的评论

Walter Roberson 2020-5-21

fillmissing can fill '' to a preferred text.

Forrest Ward 2020-5-22

Thank you guys very much for the help! I think I'm getting it now!!

请先登录，再进行评论。

更多回答（1 个）

Jeremy Hughes 2020-5-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/528363-using-spreadsheet-column-headers-as-variable#answer_435538

在 MATLAB Online 中打开

When you create import options from scratch, you need to specify all the information, including where the variablenames and data are.

function DataTable = ReadDataTable(filename)
opts = spreadsheetImportOptions('NumVariables',6);
opts = setvaropts(opts,'FillValue','0');
opts.PreserveVariableNames = true;
% You need to specify where to read the variable names from.
opts.VariableNameRange = 'B1';
opts.DataRange = 'B2';
opts.RowNamesRange = 'A2'
DataTable = readtable(filename,opts,'ReadVariableNames',true,'ReadRowNames',true);
end