How to get a vector from an excel sheet
Show older comments
I have an excel sheet from which I am reading the data using xlsread function. But it stores the output in a matrix. I want the output in a vector. Is there any way to do it directly. Or else how to convert the matrix thus obtained into a vector?
thank you, Debanjan
Answers (2)
pietro
on 20 Oct 2014
0 votes
xlsread can read a specific range so in case your range is a column you get a column array.
Ken Atwell
on 20 Oct 2014
Conversion from matrix to vector is:
>> x = x(:);
Categories
Find more on Use COM Objects in MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!