cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

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

주봉_10843142
6-Contributor

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

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions

1 REPLY 1

image.pngimage.png

Top Tags