How to select specific data from an excel file which consists of more than 1 row and more than 1 column of data
1 ビュー (過去 30 日間)
I am trying to programme a way where the user can select a specific data from my excel file. The excel file consists of 13rows and 6 columns with the first collumn and first row as headings. I want to make it so the user selects heading 1 then selects heading 2 and then print out the value that corresponds to the 2 selected headings.
回答 (1 件)
Rishabh Singh 2021 年 12 月 7 日
Considering the excel data as in below,
table = readtable("Example.xlsx"); % read excel file from the directory
%access the heading
heading1 = table.X1;
heading2 = table.X2;
Hope this helps.