readmatrix non-adjacent columns

16 次查看（过去 30 天）
Jacob Matson
Jacob Matson 2020-8-16
编辑： 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?

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

采纳的回答

Walter Roberson
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.
https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html#bvetiw8-1_sep_shared-SelectedVariableNames
  1 个评论
Jose Carrasco
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!

Translated by