readmatrix non-adjacent columns
26 views (last 30 days)
Show older comments
Jacob Matson
on 16 Aug 2020
Edited: Walter Roberson
on 5 Nov 2023
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 Comments
Accepted Answer
Walter Roberson
on 17 Aug 2020
Edited: Walter Roberson
on 5 Nov 2023
readmatrix accepts import options generated with detectImportOptions. You can use selectedVariables option to indicate which variables to read.
1 Comment
Jose Carrasco
on 5 Nov 2023
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.
More Answers (0)
See Also
Categories
Find more on Spreadsheets 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!