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

1 次查看(过去 30 天)
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
  1 个评论
Evan
Evan 2013-7-9
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.

请先登录,再进行评论。

采纳的回答

John
John 2013-7-10
编辑:John 2013-7-10
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]).

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by