How to store and use table variable name

10 visualizaciones (últimos 30 días)
Jack Oswald
Jack Oswald el 16 de Nov. de 2020
Comentada: Jack Oswald el 16 de Nov. de 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!

Respuesta aceptada

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

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Productos


Versión

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by