How to convert 183*5 matrix data into column vector data

2022 1 2
2 个回答
回答已采纳
更新时间：2022 1 2
2 次查看（30 天）

0 个投票

I am wondering how to convert excel data in 183*5 matrix into column vector data.
I hope to get the general code that converts excel data in m*5 matrix as well as 183*5 into column vector data.
plz, help me and refer to the attached excel file.
Also, Since it is a ground acceleration value, it must be arranged in order.

请先登录，再回答此问题。

 采纳的回答

KSSV
KSSV 2022-1-2

0 个投票

T = readtable('data.xlsx') ;
T = table2array(T) ;
T = T' ;
T = T(:) ;
plot(T)

更多回答（1 个）

Matt J
Matt J 2022-1-2
Ran in:

0 个投票

Ran in:
You mean like this?
x=rand(183,5);
y=x(:);
whos x y
Name Size Bytes Class Attributes x 183x5 7320 double y 915x1 7320 double

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by