readmatrix non-adjacent columns

Question

Jacob Matson 2020-8-16

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/580347-readmatrix-non-adjacent-columns

编辑： Walter Roberson 2023-11-5

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2020-8-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/580347-readmatrix-non-adjacent-columns#answer_480804

编辑：Walter Roberson 2023-11-5

readmatrix accepts import options generated with detectImportOptions. You can use selectedVariables option to indicate which variables to read.

https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html#bvetiw8-1_sep_shared-SelectedVariableNames

1 个评论
显示 -1更早的评论隐藏 -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.

请先登录，再进行评论。