copy text and numeric data from excel and make a matrix in matlab

13 次查看（过去 30 天）

GMDI 2019-4-28

评论： Walter Roberson 2019-4-28

I have following data in excel –

A 1 5

B 2 6

C 3 7

D 4 8

E 5 9

F 6 10

I want to create a matrix K in matlab using above data-

K=[A	1	5
B	2	6
C	3	7
D	4	8
E	5	9
F	6	10];

If I directly copy in matlab I get following error:

“Error using horzcat

Dimensions of arrays being concatenated are not consistent. “

“K=[A 1 5”

Is it possible to directly copy the combination of text and numerical data from excel and paste it into matlab so that K can be a 6*3 matrix?

Actually I want to use K(:,1) in later part of my code. For example- I want to get

K(1,1)= A  
K(2,1)= B
.
.
.
K(6,1)=F

My real K matrix is huge in the excel file. I just showed here only few.

Thank you.

per isakson 2019-4-28

I don't think it's possible.

Walter Roberson 2019-4-28

The problem is combining text and numeric in a single array. The array needs to be a cell array or a table to do that usefully.

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

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

Translated by