How to store and use table variable name

Question

Jack Oswald 2020-11-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/649033-how-to-store-and-use-table-variable-name

评论： Jack Oswald 2020-11-16

I'm creating a function to grab data from a hefty Excel sheet. I want the function input to determine the data I grab. Ex, in this case prices is the column header (table variable name) for the data I care about.

grab_data('12345.xlsx','prices')

function data_out = grab_data(filename,data_to_grab)

data=readtable(filename);

for h = [1:height(data)]

data_out(end+1)=data.data_to_grab(h)

end

When I run something like this, I get an error that there is no table variable name 'data_to_grab'. It's reading the name of the variable literally. Please help!