How do I make a code that store large amount of information from excel into a matrix?
1 回表示 (過去 30 日間)
古いコメントを表示
Mohammad Danial Bin Kamarul Zaman
2019 年 2 月 15 日
コメント済み: Kevin Phung
2019 年 2 月 15 日
I'm trying to recreate the following data in excel sheet and store them in a matrix using MATLAB. Unfortunately, I could not think of the best way to handle this amount of information using MATLAB. Below I have attached the current code that I have and the excel sheet.

clear
clc
numData1=xlsread('Original2.xlsx','original');
FrontFaceElements1=numData1(:,1);
FrontFaceElements1_stress=numData1(:,2);
%Total elements and nodes
%Assemble all nodes and its coordinates in a single matrix
TotalNodes=numData1(:,13);
TotalNodesX=numData1(:,14);
TotalNodesY=numData1(:,15);
TotalNodesZ=numData1(:,16);
TotalNodesMatrix(:,1)=TotalNodes;
TotalNodesMatrix(:,2)=TotalNodesX;
TotalNodesMatrix(:,3)=TotalNodesY;
TotalNodesMatrix(:,4)=TotalNodesZ;
TotalElements=numData1(:,18);
TotalElementstress=numData1(:,19);
%Coordinates of each elements
admittedly, I feel a bit stuck about this. Rather than continuing, I’m wondering if I could lean on your expertise and insights to learn how to do it. Appreciate any form of help. Thank you soo much :)
2 件のコメント
採用された回答
Kevin Phung
2019 年 2 月 15 日
Are you trying to do this:
m = numData1(:,[1:12]);
this should give you a matrix with the first row corresponding to the element number, and the other columns being the node data
2 件のコメント
Kevin Phung
2019 年 2 月 15 日
glad to have helped :).
Here's some documentation that might be even more helpful to you:
https://www.mathworks.com/help/matlab/math/array-indexing.html
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Data Export to MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!