How to extract user defined data from excel sheet?

1 次查看（过去 30 天）
adi kul
adi kul 2016-6-17
评论： Image Analyst 2016-6-17
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.
  2 个评论
cbrysch
cbrysch 2016-6-17
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
adi kul 2016-6-17
yes. You got it correctly. But could you explain with example?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Shameer Parmar
Shameer Parmar 2016-6-17
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..

更多回答（1 个）

Image Analyst
Image Analyst 2016-6-17
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by