How do I load the desired columns and rows I want from a csv file?
11 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (2 件)
Sulaymon Eshkabilov
2019 年 10 月 11 日
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 件のコメント
Walter Roberson
2019 年 10 月 12 日
readtable() with 'HeaderLines', 1 and 'ReadVariableNames', false
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Data Import and Export についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!