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

2 visualizzazioni (ultimi 30 giorni)
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 Commento
dpb
dpb il 1 Dic 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...

Accedi per commentare.

Risposte (1)

Rishabh Singh
Rishabh Singh il 7 Dic 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 Commenti
Dedong Huang
Dedong Huang il 10 Dic 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 il 10 Dic 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.

Accedi per commentare.

Prodotti


Release

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by