How to select specific data from an excel file which consists of more than 1 row and more than 1 column of data

4 views (last 30 days)
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 Comment
dpb
dpb on 1 Dec 2021
Look at
doc uigetfile
doc sheetnames
doc listdlg
doc readtable
Those and examples given for using them should let you put together a tool pretty quickly...

Sign in to comment.

Answers (1)

Rishabh Singh
Rishabh Singh on 7 Dec 2021
Hi,
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.
  2 Comments
Dedong Huang
Dedong Huang on 10 Dec 2021
Hello,
Thank you for the response. I just tried it for my code, but it returns this message:
"Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating
variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
Error using tester (line 4)
Unrecognized table variable name 'Temp'."
I have checked my Excel file and the titles appear to be correct.
Can you help with this?
dpb
dpb on 10 Dec 2021
Not without seeing the actual complete code and the error in context -- and attaching the file would never hurt; we can't really guess what the variable names might be...
At a minimum show us what
table = readtable("YourFile.xlsx");
table.Properties.VariableNames
returns.

Sign in to comment.

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!