How to extract user defined data from excel sheet?
2 次查看(过去 30 天)
显示 更早的评论
Hello All, I need help in extracting specific data from excel files. The example file screenshot is attached:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/154080/image.png)
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
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
采纳的回答
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
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.
2 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!