Save data to excel

John zink · February 19, 2022, 15:26

Hi friends
do you know how i can write a udf that save velocitie and reynoldz number values in determined points in porous media in a geometry on 2 columns in excel file?
Thanks

jps115 · February 21, 2022, 05:22

Hey John,

You can use the typical i/o functions of C to write data to file, such as fprintf (for a text file, easily opened in excel/matlab/...) or fwrite (for a binary file, which is more storage friendly but takes more effort to read, use this if storage is critical)

I would suggest to use txt commands.

/surface/point-surface to specify your sampling point.
/solve/monitors/surface/set-monitor to start writing your sampled quantity to file this will generate an .out file wish you can convert to txt file and read into excel.

Good luck!

******************************
press LIKE if this message was helpful

February 19, 2022, 15:26	Save data to excel	#1
John zink New Member Join Date: Feb 2022 Posts: 2 Rep Power: 0	Hi friends do you know how i can write a udf that save velocitie and reynoldz number values in determined points in porous media in a geometry on 2 columns in excel file? Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[General] Save unsteady data from a plane in Paraview	rabz	ParaView	1	September 27, 2020 04:16
How do I import tabular data from excel to ANSYS related to the geometry of a mesh?	SteFanI	Main CFD Forum	0	September 8, 2019 11:31
X Y PLOT - Save the data	sidam	STAR-CCM+	3	July 9, 2013 09:35
Smallest binary file format to save large data	Zonexo	Main CFD Forum	2	June 2, 2008 21:25
Save User Data	Ale	Siemens	5	March 16, 2007 06:05

February 21, 2022, 05:22		#2
jps115 New Member Jeroen de Graaff Join Date: Feb 2022 Posts: 9 Rep Power: 4	Hey John, You can use the typical i/o functions of C to write data to file, such as fprintf (for a text file, easily opened in excel/matlab/...) or fwrite (for a binary file, which is more storage friendly but takes more effort to read, use this if storage is critical) I would suggest to use txt commands. /surface/point-surface to specify your sampling point. /solve/monitors/surface/set-monitor to start writing your sampled quantity to file this will generate an .out file wish you can convert to txt file and read into excel. Good luck! ****************************** press LIKE if this message was helpful