How to store and use table variable name

6 Ansichten (letzte 30 Tage)
Jack Oswald
Jack Oswald am 16 Nov. 2020
Kommentiert: Jack Oswald am 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!

Akzeptierte Antwort

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

Weitere Antworten (0)

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Produkte


Version

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by