How to store and use table variable name

10 views (last 30 days)
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
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!

Accepted Answer

Walter Roberson
Walter Roberson on 16 Nov 2020
data_out(end+1) = data.(data_to_grab)(h)

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2020b

Community Treasure Hunt

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

Start Hunting!