How do I load the desired columns and rows I want from a csv file?
11 views (last 30 days)
Show older comments
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
0 Comments
Answers (2)
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
Walter Roberson
on 12 Oct 2019
readtable() with 'HeaderLines', 1 and 'ReadVariableNames', false
0 Comments
See Also
Categories
Find more on Data Import and Export in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!