How do I make a code that store large amount of information from excel into a matrix?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Mohammad Danial Bin Kamarul Zaman
le 15 Fév 2019
Commenté : Kevin Phung
le 15 Fév 2019
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 commentaires
Réponse acceptée
Kevin Phung
le 15 Fév 2019
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 commentaires
Kevin Phung
le 15 Fév 2019
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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Export to MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!