Import entire row instead of range from excel
11 次查看(过去 30 天)
显示 更早的评论
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!
0 个评论
采纳的回答
KSSV
2020-10-29
T = readtable(file) ; % suggested
data = xlsread(file) ;
2 个评论
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')
更多回答(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!