Extracting the whole column from excel file and putting it in a new excel file?

Hello I have excel file that contains the things that I need and things that I don't.

 text1.xls
 Jshgfy Kashs Klaksh Item Khabsd Hsgbana Quantity
  1       2     4     1     4      4        1
  1       3     4     24    4      2        3
  2       2     3     2     1      1        1

Things that I need are the item and quantity column. This is what I tried.

 fh = xlswrite('texxt.xls'); % created a new file
 [num text raw] = xlsread ['text1.xls];

I took raw and did strcmp(raw, item) to find the position of item on the xls file but I got an error. How do I find the position of item and quantity and extract the whole column and put in the new file?

Thank you.

[per isakson]

xlsread['text1.xls]; rather than xlsread('text1.xls'); is that a typing mistake? Use copy&paste!

What exactly did you try and what error message did you get?

[Kratos]

I did write xlsread('text1.xls'); after typing this I got num text and raw. After this I tried

 t = {'item'}
 strfind(raw, t)

to find if the first row had item. It gave me an error saying

 Error using cell/strfind(line32)
 if any of the input argument are cell array, the first must be a cell   array of strings and the second must be a character of array.

Answer 1

[Image Analyst]

Do you not know in advance what column number 'item' may be in? Use ismember() to find the column number if you can't use a known, predetermined column number.

[Kratos]

Thanks ismember() worked.

[Kratos]

I still have a question. When I use

 ismember(a, {'Item'})
 [0 0 1 0 0]

Now I know that it is on the third column. How do I extract the whole column? I know I can use

 [num text] = xlsread(a, 'C:C')

But since the column can be anywhere how do I make sure that I am extracting the right column?

[Image Analyst]

Try this:

ca = {'Jshgfy', 'Kashs', 'Klaksh', 'Item', 'Khabsd', 'Hsgbana', 'Quantity'}
[ia, ib] = ismember(ca, {'Item'})
letter = find(ia) + 'A' - 1
cellReference = sprintf('%c:%c', letter, letter)

[Kratos]

Thank you.