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

10 次查看（过去 30 天）
Changhyun Kim
Changhyun Kim 2022-1-2
回答： KSSV 2022-1-2
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
T = readtable('data.xlsx') ;
T = table2array(T) ;
T = T' ;
T = T(:) ;
plot(T)

更多回答（1 个）

Matt J
Matt J 2022-1-2
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

类别

在 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