Import entire row instead of range from excel

15 vues (au cours des 30 derniers jours)
Noa Hoogeweg
Noa Hoogeweg le 29 Oct 2020
Commenté : Noa Hoogeweg le 29 Oct 2020
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!

Réponse acceptée

KSSV
KSSV le 29 Oct 2020
T = readtable(file) ; % suggested
data = xlsread(file) ;
  2 commentaires
Walter Roberson
Walter Roberson le 29 Oct 2020
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 le 29 Oct 2020
Thanks! I did the following:
file = readtable(filename, 'Sheet', 'Scans')
file([2:2], :))
This worked and imported the entire row!

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by