清空筛选条件
清空筛选条件

Import entire row instead of range from excel

11 次查看（过去 30 天）
Noa Hoogeweg
Noa Hoogeweg 2020-10-29
评论： Noa Hoogeweg 2020-10-29
Hello!
Is there a way to import an entire row from excel in matlab?
So instead of:
[file] = xlsread(filename, 'Scans', 'A2:M2')
I want something like:
[file] = xlsread(filename, 'Scans', '2')
However, this of course doesn't work..
I can't use a range since the length of the row is unknown. (Of course it is not really unknown, but I want to analyze multiple excel data and not having to change the range every time).
Another important thing is: all rows have different sizes in my excel document, so using size(file) also doesn't work.
I hope someone can help me, thanks!

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

采纳的回答

KSSV
KSSV 2020-10-29
T = readtable(file) ; % suggested
data = xlsread(file) ;
  2 个评论
Walter Roberson
Walter Roberson 2020-10-29
If you use readtable with a 'range' then
"Range must be of the form 'A1' (cell), 'A:B' (column-select), '1:5' (row-select), 'A1:B5' (rectangle-select), or a valid named range in the sheet."
So you could use 'range', '2' to get row 2. (You might perhaps need '2:2')
Noa Hoogeweg
Noa Hoogeweg 2020-10-29
Thanks! I did the following:
file = readtable(filename, 'Sheet', 'Scans')
file([2:2], :))
This worked and imported the entire row!

请先登录，再进行评论。

更多回答（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