Read columns/rows from cvs
显示 更早的评论
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 个评论
Maximilian Jatzkowski
2018-11-29
madhan ravi
2018-11-29
Try using xlsread() with specified range by referring the doc to read the ranges
Maximilian Jatzkowski
2018-11-29
回答（1 个）
Alok Nimrani
2018-12-6
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
类别
在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息
2018-11-29
2018-12-6
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
