Skip to main content
6-Contributor
April 28, 2024
Solved

How to extract the several Sol Data to one Excel sheet through WRITEEXCEL function?

  • April 28, 2024
  • 1 reply
  • 846 views

Hello Experts,

 

Please help me with the Subject issue, "How to extract the several Sol Data to one Excel sheet through "WRITEEXCEL" function?"

 

In order to reduce repeated works as I should handle many cases, I want to extract several Sol Data into one Excel Sheet file but no idea :((

 

Please check the attached mcdx file for the following questions.

1. How to get all of the data values(Sol, Fy, y, y1, Fx) highlighted with yellow color in one sheet of Excel file by using "WRITEEXCEL" fucntion?

 

2. The value of Fx is same for all the variables of each matrix row which shouldn't be correct. Is there any mistake for that?

 

Please give me any advice or solution. will be much appreciated.

 

Best answer by ttokoro

image.pngimage.png

1 reply

ttokoro
21-Topaz I
ttokoro21-Topaz IAnswer
21-Topaz I
April 28, 2024

image.pngimage.png

t.t.