CFD Online Discussion Forums

CFD Online Discussion Forums (https://www.cfd-online.com/Forums/)
-   STAR-CCM+ (https://www.cfd-online.com/Forums/star-ccm/)
-   -   Reading MS Excel Data in STAR-CCM+ using a Macro (https://www.cfd-online.com/Forums/star-ccm/76232-reading-ms-excel-data-star-ccm-using-macro.html)

BrenS May 18, 2010 17:07

Reading MS Excel Data in STAR-CCM+ using a Macro
 
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 14:38

JAVA api for interfacing with OpenOffice & MicroSoft Office products
 
http://poi.apache.org/index.html


All times are GMT -4. The time now is 09:18.