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 Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by