How to access objects in HYSYS

[hiokdat]

Dear franktoffel:
I am a graduate student majored in Chemical Engineering from Taiwan. Recently, I am learning how to do access HYSYS by COM using Python codes, and Google leads me to your project here in Github. It's very nice of you to provide such a good example in public platform; thank you very much.
Here is my problem: How can I know the exact name of a variable that I want to access. For example, I want to access the composition value of a certain material stream, how can I know I should use the name "ComponentMolarFractionValue"? Is there any list or resources that users may refer to?
Best regards,
hiokdat

[aliglara]

Hello

I'm far away to an expert in this area. However, my best approach to deal with Hysys’ object names is using its Aspen simulation Workbook first. You can manage all you need from your simulation case through Excel and catch any pieces of name your need (digging a little into its VBA codes)
Then you can switch to python or Matlab

[Kevin1129]

Hi hiokdat, If you use HYSYS, you don’t need to know the exact name of a variable to access it. My solution is to use spreadsheet in HYSYS and store variable values in it, and you only need to access to the spreadsheet unit to read/write them. Best, Kai Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

…

________________________________ From: hiokdat <[email protected]> Sent: Friday, January 18, 2019 8:55:16 PM To: CAChemE/stochastic-optimization Cc: Subscribed Subject: [CAChemE/stochastic-optimization] How to access objects in HYSYS (#1) Dear franktoffel: I am a graduate student majored in Chemical Engineering from Taiwan. Recently, I am learning how to do access HYSYS by COM using Python codes, and Google leads me to your project here in Github. It's very nice of you to provide such a good example in public platform; thank you very much. Here is my problem: How can I know the exact name of a variable that I want to access. For example, I want to access the composition value of a certain material stream, how can I know I should use the name "ComponentMolarFractionValue"? Is there any list or resources that users may refer to? Best regards, hiokdat — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#1>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AXHsJpzAa-62afPFWxTOVNmb0uNd-OSxks5vEnsEgaJpZM4aI5r0>.

[HamidToliati]

Hello
First of all, thanks for the useful shared materials.
I wanted to connect HYSYS to SQL to store its dynamic simulation data and also, I want to do this by means of python. Unfortunately, I do not find any documentation on this topic.
Can you please, guide me through this?
Thanks

[aliglara]

Hello In the past, I tried to make that connection, but I couldn’t. So, in the end, my thought was Aspen products rely heavily on Windows’ platform and VBA codes that make a cumbersome task using another language as an external handler. Now, I’m not working anymore on Windows, and I have no access to Aspen software. Thus, unfortunately, I am not able to help you. Sorry by that On Jun 14, 2021, at 4:03 AM, HamidrezaToliati ***@***.***> wrote: Hello First of all, thanks for the useful shared materials. I wanted to connect HYSYS to SQL to store its dynamic simulation data and also, I want to do this by means of python. Unfortunately, I do not find any documentation on this topic. Can you please, guide me through this? Thanks — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEPDJOVNZRGSJRVFGJRDQUDTSWZTZANCNFSM4GRDTL2A> .

[HamidToliati]

Thanks very much for the answer.
I have another question which is how did you decipher different VBA methods and their application. Because when I add the HYSYS library to the VBA window, there is no description for the methods and their subsets. I wanted to know if there is any documentation or a way to access their description
Thanks much

[aliglara]

Hello There is no well-documented manual of those VBA modules. Actually, I couldn’t figure out why there were two approaches to get the same result. Because of that, I used the more straightforward approach for me, and I implemented only the methods/functions that worked for me. To be honest, it was a tricky implementation based on lots of tries and errors. I hope this helps

On Thu, Jun 17, 2021 at 6:35 AM HamidrezaToliati ***@***.***> wrote: Thanks very much for the answer. I have another question which is how did you decipher different VBA methods and their application. Because when I add the HYSYS library to the VBA window, there is no description for the methods and their subsets. I wanted to know if there is any documentation or a way to access their description Thanks much — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#1 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEPDJOTW3WA62H5PNO7GGDDTTHFYXANCNFSM4GRDTL2A> .

-- Prof. Ali Gabriel Lara Chemical Engineering School @ UCV Twitter name: @aliglara Phone number: +1 (614) 441-8664