清空筛选条件
清空筛选条件

how to read different columns from excel but write in the same variable in matlab?

2 次查看（过去 30 天）
vivian0925
vivian0925 2016-3-3
评论： Bob 2016-3-3
Hello everyone, i´m quite new with matlab. I have one excel file and want to read the data with matlab script and plot them.
Due to the data is very big, i can´t fit them only with 4 columns in excel but with 8 columns (as you can see in the image above), i don´t know how i can change my script so that it will read all the 8 columns data but write in the same variable. For example: For A1 A5 A9... and E1 E5 E9... these values are belong to the same variable "Time", so i write in my script:
num=xlsread('Rxxx.xlsx','Tabelle1','A1:H1048576');
Time=num(1:4:end,1);
but it doesn´t read the column E1 E5 E9... but i need these value also saved in the same variable "Time"
How can i correct my script so it read read also E to H columns ? I have attached a sample of the excel file.
Thank you and best regards.
Vivian

请先登录，再回答此问题。

采纳的回答

Bob
Bob 2016-3-3
编辑：Bob 2016-3-3
I can't understand what exactly you want Mrs.
Do you only need to read column A1 A5 A9... E1 E5 E9....?
%%Read Column A
A=xlsread('R','A1:A40');
a=A(1:4:end);
%%Read Column E
E=xlsread('R','E1:E40');
e=E(1:4:end);
Time=[a;e];

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by