Jump to content

Recommended Posts

Hi

 

I want to be able to optimize a model implemented as an Excel workbook. I know that in CAESES there is a COM interface for connecting with Excel but I do not know how to use it and what are the functionalities available.

 

Could anyone give me some guidance on how to:

1. Connect CAESES with an existing Excel workbook file <*.xlsm>

2. Change values in some given cells

3. Read values from some given cells

4. Write results to a new Excel file

 

Some examples would be quite wellcome.

Thank you in advance.

 

Best regards

Manuel ventura

 

 

 

 

Share this post


Link to post
Share on other sites

Hi Manuel,

 

Please find attached a reviewed feature definition (just put it into your feature user directory in your friendship app data folder). It should show you how to do step 1-3, as far as I remember. I am not sure about your step 4, maybe other users have more experience with this?

 

Cheers

Joerg

COMconnection.fdf

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...