How do I make a code that store large amount of information from excel into a matrix?

Question

Mohammad Danial Bin Kamarul Zaman 2019-2-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/445222-how-do-i-make-a-code-that-store-large-amount-of-information-from-excel-into-a-matrix

评论： Kevin Phung 2019-2-15

Original2.xlsx

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.

Looking for ways to assemble a matrix that looks like this.JPG

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

so what are you trying to do?

Mohammad Danial Bin Kamarul Zaman 2019-2-15

Good question haha. I'm trying to create a loop matrix that starts from 1X1 (value 15 as shown in the picture) to the final row lets say nX1. At the same time, it saves all the nodes corresponds to the element as shown in the figure.

I really appreciate it if you could give an opinion about this.

请先登录，再进行评论。

请先登录，再回答此问题。