Search string and get its position in excel using Actxserver

2018 3 7
1 个回答
更新时间：2018 3 8
5 次查看（30 天）

0 个投票

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".

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

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2018-3-7

0 个投票

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
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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

提问:

Ghenji
Ghenji
2018-3-7

评论：

Ghenji
Ghenji
2018-3-8

Community Treasure Hunt

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

Start Hunting!

Translated by