How to store and use table variable name

조회 수: 10 (최근 30일)
Jack Oswald
Jack Oswald 2020년 11월 16일
댓글: 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
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!

채택된 답변

Walter Roberson
Walter Roberson 2020년 11월 16일
data_out(end+1) = data.(data_to_grab)(h)

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by