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

38 ビュー (過去 30 日間)
GMDI
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.
  2 件のコメント
per isakson
per isakson 2019 年 4 月 28 日
Walter Roberson
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.

サインインしてコメントする。

回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by