copy text and numeric data from excel and make a matrix in matlab
38 ビュー (過去 30 日間)
古いコメントを表示
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
2019 年 4 月 28 日
I don't think it's possible.
"K matrix is huge", see readtable Create table from file and xlsread (Not recommended) Read Microsoft Excel spreadsheet file
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 Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!