Read columns/rows from cvs
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hi!,
Im trying to read data from a csv file into matlab, and i want a specific column with a speficic range of rows. How do i do this? The code im trying to use is this:
temperatur17=readcsv('temperatur.csv',3289,3,[3289 3 3655 5])
so basically, i want to read only rows 3290 to 3654, and only column 4, to get a vector.
Thanks in advance!
3 Commenti
madhan ravi
il 29 Nov 2018
Try using xlsread() with specified range by referring the doc to read the ranges
Risposte (1)
Alok Nimrani
il 6 Dic 2018
Hi Maximilian,
As suggested earlier, you can make use of 'xlsread()' to read values from a particular column for some specific rows. In your case, you can read column 4 values for rows numbered 3290 to 3654 as follows:
>> A = xlsread('temperature.xls','D3290:D3654');
Here, you can also specify the sheet number from which to read as follows:
>> sheet = 1;
>> A = xlsread('temperature.xls',sheet,'D3290:D3654');
By default, the sheet number is 1.
For more information, you may have a look at the following link: https://www.mathworks.com/help/matlab/ref/xlsread.html
Hope this helps.
Regards,
Alok
0 Commenti
Vedere anche
Categorie
Scopri di più su Data Import and Export 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!