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

11 views (last 30 days)
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

Answers (2)

Sulaymon Eshkabilov
Sulaymon Eshkabilov on 11 Oct 2019
Hi,
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.
  2 Comments
Format_31
Format_31 on 12 Oct 2019
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?

Sign in to comment.


Walter Roberson
Walter Roberson on 12 Oct 2019
readtable() with 'HeaderLines', 1 and 'ReadVariableNames', false

Categories

Find more on Data Import and Export in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!