Loading a excel file in which I want to take only B, D not C , how can it be done?

Hi,

I have a question regarding reading in the data from Excel. I have to import the data as a combination of two columns, e.g. column A and C, column B and D.

But if I use the xlsread function, I can only read in the data as a combination of two columns being next to each other, e.g. A and B, or B and C.

Your help is appreciated.

Thanks, Julia

[Evan]

I am also interested in whether or not this is possible without multiple xlsread calls, so I'm commenting here so I can follow this thread.

Answer 1

[John]

The best way to do this is call xlsread() once (read in all the data) and index the data you need:

     data = xlsread('test.xlsx');
     AC = data(:, [1 3]);
     BD = data(:, [2 4]);

data(:, [1 3]) means take all rows (:) and columns 1 and 3 ([1 3]).

[Julia]

John, you just saved me hours of work!!!!! It solves my problem, many thanks!!!