Search string and get its position in excel using Actxserver

Question

Ghenji 2018-3-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/386874-search-string-and-get-its-position-in-excel-using-actxserver

评论： Ghenji 2018-3-8

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Fangjun Jiang 2018-3-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/386874-search-string-and-get-its-position-in-excel-using-actxserver#answer_308866

在 MATLAB Online 中打开

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.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ghenji 2018-3-8

xlsread might be time consuming if I want to read many excel files with sheet "kharif". Now I have the keyword If I can go to that position and then read whole column below would indeed save time. Cotton is not a header so that doesn't help. Anyway Thank you for your suggestion.

请先登录，再进行评论。