Using SAM with Excel

  • Victor Enzo
  • Topic Author
More
14 Jan 2015 07:00 #2917 by Victor Enzo
Using SAM with Excel was created by Victor Enzo
Hi,
I would like to use input from an Excel file to run a simulation in SAM and maybe make SAM to write the results in another Excel file (automatically). Is this, or something similar, possible?

Thanks in advance

Please Log in or Create an account to join the conversation.

  • pgilman
More
14 Jan 2015 14:51 #2918 by pgilman
Replied by pgilman on topic Using SAM with Excel

Please Log in or Create an account to join the conversation.

  • Victor Enzo
  • Topic Author
More
15 Jan 2015 02:42 #2919 by Victor Enzo
Replied by Victor Enzo on topic Using SAM with Excel
Dear Paul

Thank you for the fast reply. I was able to run the LKscript downloaded from the SAM Sample Files page. Can I run the script from external programs? (like an Excel macro).

Thanks in advance

Please Log in or Create an account to join the conversation.

  • pgilman
More
15 Jan 2015 10:51 #2920 by pgilman
Replied by pgilman on topic Using SAM with Excel
Dear Victor,
It is not possible to set the value of SAM inputs from outside of SAM.
However, if you are a software programmer, you can use the SAM software development kit to run SAM simulation modules without the SAM user interface. The SDK is a set of tools to work with the SAM Simulation Core (SSC) application programming interface (API). You can access the API in its native C, or using the language wrappers we've written for Java, C#, Python and MATLAB. We are considering writing a Microsoft VBA wrapper in the future, but do not have one now.
Best regards,

Paul.

Please Log in or Create an account to join the conversation.

  • Victor Enzo
  • Topic Author
More
19 Jan 2015 03:27 #2921 by Victor Enzo
Replied by Victor Enzo on topic Using SAM with Excel
Dear Paul,

I'll try to solve my problem in a different way.
Thank you for your help.

Best regards,
Victor

Please Log in or Create an account to join the conversation.

Moderators: pgilman
Powered by Kunena Forum