Search string and get its position in excel using Actxserver
3 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Fangjun Jiang
2018-3-7
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!