How to extract user defined data from excel sheet?

Hello All, I need help in extracting specific data from excel files. The example file screenshot is attached:

Now what I want is, to extract data for Data Point 121 for Para2, Para4, Para7

The issue is, I have many excel sheets to process and the don't have fixed column. Meaning, some files have Data point column at "C", Para1 maybe at "H", etc. Only headers "Data Point", "Para1",...."Para10" have same names.

I hope you are getting my problem. Please advice me on extracting such specific data based on the headers, not the column range.

[cbrysch]

If I get your question right you want to extract a data point under e.g. Para6 and 8, but the column number is not always the same for different excel data sets? One way to get your data would be to find the column number you are interested in using strcmp() in an loop to check if you are in the correct column. Hope this helps

[adi kul]

yes. You got it correctly. But could you explain with example?

Answer 1

[Shameer Parmar]

Hello Ali,

Please find attached code and input data sheet.

Keep it in matlab current directory and run the sheet.m file

It will ask you to enter the Data Point number and Para number, just enter the number and you will get the corresponding data as output..

 Example:
 Please enter the Data Point number = 121
 Please enter Para number = 6

 output =

    87

read the code and modified as per your requirement.. Let me know if you stuck anywhere..

[adi kul]

exellent!!

Answer 2

[Image Analyst]

You're going to have to read in the whole workbook with xlsread() and then use strfind() or strcmpi() to examine the column headers to figure out what column(s) you need.

[adi kul]

Can you explain with an example?

[Image Analyst]

Looks like you've already accepted an answer without demo code to do that.