how to read different columns from excel but write in the same variable in matlab?
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!