How to get a vector from an excel sheet

조회 수: 13 (최근 30일)
Debanjan Dasgupta
Debanjan Dasgupta 2014년 10월 20일
답변: Ken Atwell 2014년 10월 20일
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

답변 (2개)

pietro
pietro 2014년 10월 20일
xlsread can read a specific range so in case your range is a column you get a column array.

Ken Atwell
Ken Atwell 2014년 10월 20일
Conversion from matrix to vector is:
>> x = x(:);

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by