Create a range from a given cell using xlsread

Question

0 个投票

Is it possible to search for a given string in a column A of an excel sheet, then obtain the number in the same row, but in column B and then to use this number as the last value in a range:

i.e. if the number in the cell adjacent to where "Count" is is 15000, the perform:

[ndata, text]=xlsread(file,'A1:A15000');

Thanks Jason

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Follow Question

Answer 1

Jason 2015-4-10

在 MATLAB Online 中打开

0 个投票

I think I've worked out the solution:

[~,~,rawData] = xlsread(file,'A1:A50')
 dummy='Count';
 idx=find(strcmp(rawData(:),dummy),1)
 ct=sprintf('B%d:B%d',idx,idx)
 [count, ~]=xlsread(file,ct)

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

Jason 2015-4-10

My excel file is saved as a CSV, is xlsread the quickest way to read in the data as there are 800k lines?

Thanks

Create a range from a given cell using xlsread

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

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

标签

Community Treasure Hunt

Create a range from a given cell using xlsread

0 个评论 显示 -2更早的评论 隐藏 -2更早的评论

回答（1 个）

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

标签

另请参阅

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

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