How to store and use table variable name
10 views (last 30 days)
Show older comments
Jack Oswald
on 16 Nov 2020
Commented: Jack Oswald
on 16 Nov 2020
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!
0 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!