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 Spreadsheets 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!