readmatrix non-adjacent columns
26 次查看(过去 30 天)
显示 更早的评论
I would like to import 3 columns of a excel/csv file into a matrix. The columns I want are non-adjacent (Columns C, P, Q). I can import all the columns between C-Q adjacent columns like:
M=readmatrix('file.csv', 'Range', 'C:Q' );
However, I don't wan't columns D-O. I try things like this and it doesn't work.
M=readmatrix('file.csv', 'Range', 'C:C, C:Q' );
How do I only import the 3 colmns C, P, Q into 1 matrix?
0 个评论
采纳的回答
Walter Roberson
2020-8-17
编辑:Walter Roberson
2023-11-5
readmatrix accepts import options generated with detectImportOptions. You can use selectedVariables option to indicate which variables to read.
1 个评论
Jose Carrasco
2023-11-5
I would further point out that import options available in one variable can be assessed before using opts.SelectedVariableNames by running detectImportOptions(variable) on it.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!