Info

此问题已关闭。 请重新打开它进行编辑或回答。

Create a range from a given cell using xlsread

2 次查看（过去 30 天）
Jason
Jason 2015-4-10
关闭： MATLAB Answer Bot 2021-8-20
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

此问题已关闭。

回答（1 个）

Jason
Jason 2015-4-10
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 个评论
Jason
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

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by