How could I read a single cell of an .csv file using readmatrix function with import options?

Question

Omar Andrés Rosada González 2020-8-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/575815-how-could-i-read-a-single-cell-of-an-csv-file-using-readmatrix-function-with-import-options

回答： Omar Andrés Rosada González 2020-8-6

Hello to everyone, I need to process different data from a .csv file. I do ask for the user what are the row ranges that need to read the code, with that, I need to save a value from a particular cell from the spreadsheet.

Next work very well for me. But I would like to know if it's possible to make this using import options.

kappa = readmatrix('1_5B_2.csv', 'Range', 'D6:D6');

Thanks in advance.

2 个评论
显示无隐藏无

dpb 2020-8-6

"possible to make this using import options."

Not sure what you mean here...explain more in detail.

Sudheer Bhimireddy 2020-8-6

Try this link to know the what import options you have for the file being read.

https://www.mathworks.com/help/matlab/ref/detectimportoptions.html

Then you can use either readtable to readmatrix with possible import options.

请先登录，再进行评论。

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

Answer 1

Omar Andrés Rosada González 2020-8-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/575815-how-could-i-read-a-single-cell-of-an-csv-file-using-readmatrix-function-with-import-options#answer_476110

在 MATLAB Online 中打开

Thank you, it was a pretty simple solution.

First I did use detectImportOptions, searching the variable name (column), then I defined the data line range (row). In my case, it would be only using the same row position on both sides. Something like the next code.

opts = detectImportOptions('1_5B_2.csv');
opts.SelectedVariableNames = ('Var4');
opts.DataLines = [range(1,1) range(1,1)];
kappa = readmatrix('1_5B_2.csv', opts);