MATLAB Answers


How do I load the desired columns and rows I want from a csv file?

Asked by Format_31 on 11 Oct 2019
Latest activity Answered by Walter Roberson
on 12 Oct 2019
With a csv file , how can I load from the second row to the last data point row in the second column from my excel data set. I have tried using readtable and csvread but can’t seem to figure out how to access the rows and column I want starting from the second row and second column.
I’m running 2018b


Sign in to comment.


2 Answers

Answer by Sulaymon Eshkabilov on 11 Oct 2019

The good solution of your exercise is to use xlsread(), e.g. DATA = xlsread('MY_data.xls', 1, 'B1:B999');
Note that the file name and extension exactly and B1:B999 means from column 2 all data from cell B1 up to B999.
Good luck.


Thank you. I tried that but it doesn’t work the same for .csv files. I’m trying to keep my time stamps in their format and it seems like the .csv file format works well for doing so but pulling accessing the correct rows and column is more challenging.
Any ideas for how to do it with a .csv file?
can you post your sample data file?

Sign in to comment.

Answer by Walter Roberson
on 12 Oct 2019

readtable() with 'HeaderLines', 1 and 'ReadVariableNames', false


Sign in to comment.