Read columns/rows from cvs

5 次查看（过去 30 天）
Maximilian Jatzkowski
回答： Alok Nimrani 2018-12-6
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 个评论
显示 1更早的评论
madhan ravi
madhan ravi 2018-11-29
Try using xlsread() with specified range by referring the doc to read the ranges
Maximilian Jatzkowski
Maximilian Jatzkowski 2018-11-29
how would that look?
xlsread(
xlsread('temperatur.xls','C3290:C3654')
or?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Alok Nimrani
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

类别

在 Help Center 和 File Exchange 中查找有关 Migrate GUIDE Apps 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by