Effacer les filtres
Effacer les filtres

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

2 vues (au cours des 30 derniers jours)
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
  2 commentaires
Bob
Bob le 3 Mar 2016
can you provide the excel data?
vivian0925
vivian0925 le 3 Mar 2016
Modifié(e) : vivian0925 le 3 Mar 2016
Sure, i have uploaded a sample of the excel file. I just want to understand how to read non-contiguous range from excel with matlab.

Connectez-vous pour commenter.

Réponse acceptée

Bob
Bob le 3 Mar 2016
Modifié(e) : Bob le 3 Mar 2016
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];

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by