Search string and get its position in excel using Actxserver
3 views (last 30 days)
Show older comments
Is it possible to search for a string in an excel file from particular sheet and also get its position. I need to get data only from this column. So if the position is known, data from that column can be imported. for ex..
fullname = 'C:\Users\Documents\MATLAB\files\food_raw.xlsm;
sheet = 'kharif';
string = 'cotton';
I want to import data present in column "cotton".
0 Comments
Answers (1)
Fangjun Jiang
on 7 Mar 2018
I will just read the Excel file anyway and search the Raw data.
[Num,Txt,Raw]=xlsread(fullname,sheet);
Or, if 'cotton' is supposed to appear in the first row as the header, you might want to consider readtable() function and put your data in a Table.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!