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

56 次查看（过去 30 天）
Omar Andrés Rosada González
回答： 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.

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

采纳的回答

Omar Andrés Rosada González
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);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by