I got the simulation results by ANSYS MAXWELL,
the solution data matrix is huge.
I am looking for an easy method to export the data into excel.
Any suggestion will be highly appreciated.
In my opinion, you can use MATLAB.
MATLAB can read a text and make a matrix from data and ANSYS can write a text from data. so you can use MATLAB for make a matrix of data.
Code of MATLAB:
.
1) if you want to write a text by MATLAB
>>fid2=fopen('foransys.txt','w');
2) if you want to read a text by MATLAB
>>fid1=fopen('foransys1.txt','r');
3) if you want to finish your text
>>A=fscanf(fid1,'%c');
>>fprintf(fid2,A);
4) if you want to switch MATLAB and ANSYS
>>dos '"C:\Program Files\ANSYS Inc\v150\ansys\bin\winx64\ANSYS150.exe" -b -i foransys.txt -o output.out';
first parameter = address of ANSYS
'"C:\Program Files\ANSYS Inc\v150\ansys\bin\winx64\ANSYS150.exe"
4th parameter = name of input
6th parameter = name of output ( output of ANSYS)
read output of ANSYS for make a matrix from data
>>fid6=fopen('outParameter','r');
>>T=fscanf(fid6,'%c');
Certainly the numbers are NOT same a number and they are "cell'
you should use it,
c= num2cell(T);
it change a cell to a number
please check these links:
Article The Topology and Weight Optimization of a Truss Using Imperi...
Article Topology and Weight Optimization of a 3D Truss by Numerical Method
Mohsen Mohebbi Thank you very much for your answer, when I have time, I'll check the works. Best regards :)
I can export the obtained data by simulation from ANsys Maxwell or Ansys simplorer by "export" tab and then save as. It's pretty easy and convenient.
Ansys gives csv format of document. The format with comma. Comma separates data. How did you get that format you show in the picture. Would you explain.
Thanks
In Ansys: Right click on the table data, then export as (.csv). You can open by excel.
When I tried to energy minimization my system, I got fatal error as below. Fatal error: Atomtype opls_116 not found Although I've already added this line: ; include water #include "oplsaa.ff/spc.itp" to [molecultype] directive in my topology.
16 June 2021 0 0 View
Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...
03 March 2021 8,796 3 View
I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance
03 March 2021 3,568 1 View
Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...
03 March 2021 5,978 5 View
What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...
03 March 2021 1,401 3 View
I have conducted and published a systematic review and meta-analysis research with the topic related to public health and health pomotion (protocol was registed in PROSPERO). Now we want to...
03 March 2021 8,920 3 View
dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...
03 March 2021 6,994 5 View