how to read different columns from excel but write in the same variable in matlab?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/156591/image.png)
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
Réponse acceptée
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!