Reading MS Excel Data in STAR-CCM+ using a Macro

BrenS · May 18, 2010, 18:07

Hello All,

I currently have a spreadsheet that automatically generates the size and position of several volume shapes that will be used for several CFD studies. Rather than add every volume shape manually, I would like to create a macro in STAR-CCM+ that reads the data from MS Excel and then automatically creates my volume shapes. I am confident I can figure out how to write the macro to create the volume shapes on my own; however, I can't seem to find out what the command is (if one exists) for reading an Excel file. For those of you who have used Matlab, I am looking for the STAR-CCM+ equivalent to the "xlsread()" command. If this is possible in STAR-CCM+ please let me know.

Regards,

Brendan S

Paulh · May 20, 2010, 15:38

http://poi.apache.org/index.html

May 18, 2010, 18:07	Reading MS Excel Data in STAR-CCM+ using a Macro	#1
BrenS New Member Brendan Smoker Join Date: May 2010 Posts: 7 Rep Power: 16	Hello All, I currently have a spreadsheet that automatically generates the size and position of several volume shapes that will be used for several CFD studies. Rather than add every volume shape manually, I would like to create a macro in STAR-CCM+ that reads the data from MS Excel and then automatically creates my volume shapes. I am confident I can figure out how to write the macro to create the volume shapes on my own; however, I can't seem to find out what the command is (if one exists) for reading an Excel file. For those of you who have used Matlab, I am looking for the STAR-CCM+ equivalent to the "xlsread()" command. If this is possible in STAR-CCM+ please let me know. Regards, Brendan S

May 20, 2010, 15:38	JAVA api for interfacing with OpenOffice & MicroSoft Office products	#2
Paulh Member Paul Hancock Join Date: Mar 2009 Location: Bellingham, WA Posts: 31 Rep Power: 17	http://poi.apache.org/index.html

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Commercial meshers] Problem converting fluent mesh	vinz	OpenFOAM Meshing & Mesh Conversion	28	October 12, 2015 07:37
[Other] StarToFoam error	Kart	OpenFOAM Meshing & Mesh Conversion	1	February 4, 2010 05:38
problem when converting mesh (made by ICEM) using fluentMeshToFoam	Forrest_Lei	OpenFOAM	11	October 16, 2009 07:28
How to update polyPatchbs localPoints	liu	OpenFOAM Running, Solving & CFD	6	December 30, 2005 18:27
[Commercial meshers] Trimmed cell and embedded refinement mesh conversion issues	michele	OpenFOAM Meshing & Mesh Conversion	2	July 15, 2005 05:15