How to get a vector from an excel sheet

7 views (last 30 days)
Debanjan Dasgupta
Debanjan Dasgupta on 20 Oct 2014
Answered: Ken Atwell on 20 Oct 2014
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
xlsread can read a specific range so in case your range is a column you get a column array.

Ken Atwell
Ken Atwell on 20 Oct 2014
Conversion from matrix to vector is:
>> x = x(:);

Community Treasure Hunt

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

Start Hunting!