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

조회 수: 1 (최근 30일)
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
Mohammad Danial Bin Kamarul Zaman
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.

댓글을 달려면 로그인하십시오.

채택된 답변

Kevin Phung
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
Mohammad Danial Bin Kamarul Zaman
yes! thank you soo much. I really appreciate it. I'm surprised, why didn't I thought of that.
Kevin Phung
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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by