14 replies to this topic

[Padmakar Katre]

Dear All,
I want to know how export a Hysys Case (.hsc file) to MS Excel File (.xls). Does it require the knowledge of the Visual Basic. I would thankful if someone gives the guideline regarding the problem.
Thanks in advance for your replies.

[Zauberberg]

Hello Padmakar,

What exactly do you need to export from Hysys file to MS Excel? Unit operation, flowsheet, stream parameters and compositions, utilities, logicals etc.?

I don't know if this will serve the purpose you need, but it is a good tool anyway: "Workbook dump", a quick Excel-based procedure for exporting Hysys workbook data into Excel file (produces a copy in Excel of the data that is being displayed in the current HYSYS workbook). Many Hysys users are familiar with this one.

Regards,

[attachment=746:Workbook_Dump.zip]

[Padmakar Katre]

Dear,
Thanks it will do for me.

[nicolasbrunner]

Hi, unfortunately this utility does not work with Hysis 2006. I ugpraded soon to this version and it was a very bad surprise. Do you know if a newer version of the dump workbook utility which could be compatible with HYSYS 2006 exists ?

[joerd]

Hi, unfortunately this utility does not work with Hysis 2006. I ugpraded soon to this version and it was a very bad surprise. Do you know if a newer version of the dump workbook utility which could be compatible with HYSYS 2006 exists ?

I don't think it exists, AspenTech probably wants you to use their Simulation Workbook now, which is no longer free.
You probably have to go into the VB editor and re-reference the proper Hysys 2006 type library. If you're lucky, the functions work again, but Hysys typically changes their object model every other version, so some exports will no longer work, or give no results. Check your answers! Once you get into VBA, it is not too hard to debug the thing, but it will take some time.
Good luck!

[JoeWong]

Hi, unfortunately this utility does not work with Hysis 2006. I ugpraded soon to this version and it was a very bad surprise. Do you know if a newer version of the dump workbook utility which could be compatible with HYSYS 2006 exists ?

I don't think it exists, AspenTech probably wants you to use their Simulation Workbook now, which is no longer free.
You probably have to go into the VB editor and re-reference the proper Hysys 2006 type library. If you're lucky, the functions work again, but Hysys typically changes their object model every other version, so some exports will no longer work, or give no results. Check your answers! Once you get into VBA, it is not too hard to debug the thing, but it will take some time.
Good luck!

Providing export utility in HYSYS would contradict with ASPEN workbook business direction.

Back to fundamental, each unit, stream, etc in HYSYS are object with properties. Using VB (or other e.g. C++) code, you would possibly extracting properties from each object in HYSYS as you wish.

Not sure if Properties extraction can be blocked by HYSYS as it is still in Object Oriented platform. It works for my last activities but not sure now...

[joerd]

Not sure if Properties extraction can be blocked by HYSYS as it is still in Object Oriented platform. It works for my last activities but not sure now...

It still works. I think one of the best features of Hysys is its accessibility via OLE/Automation. I don't think they'll change it soon since it gives a lot of added value to (some) customers, but they will try to plug their own solutions as much as they can.

[petro08]

Hi,

In relation to the workbook dump posts (file using workbookdump.xls), can some indicate how to get access to other workbooks which are contained within sub-flowsheets and not on the main flowsheet.

This is the line of code where the back door variable access the flowsheet.

Set fsBD = hyCase.Flowsheet

How does one modify this so that it can access any active flowsheet.

At the moment, it only extracts workbook data from the main flow sheet.

Thanks,

Petro08

[Alex Krenvalk]

In this situation advise try-Excel worksheet recovery,as far as i know it is free,utility can repair corrupted Microsoft Excel worksheets,restore data after problems with corrupted worksheet problem as a result of virus attack, disk and network failures or any other problem,an scan a damaged Microsoft Excel worksheet and repair it,work with *.xls, *.xlam, *.xltx, *.xlt and *.xlsm formats,recover modified Excel worksheets and shows recovered data in the same way, like it will be displayed in Microsoft Excel worksheet.

[suhas]

Can anybody pls upload workbookdump.xls file please
I need to expot the data from hysis

[wamit]

HI,

If you are registered with AspenTech, you can probably download the software, has macros connectivity to the Hysys case file.....then you can surely transfer Hysys case to excel..

Its good......

Cheers,
wamit

[Hysysadvisor]

Dear All,
I want to know how export a Hysys Case (.hsc file) to MS Excel File (.xls). Does it require the knowledge of the Visual Basic. I would thankful if someone gives the guideline regarding the problem.
Thanks in advance for your replies.

Try to use Hys link free spftware.this video indicates how to use it?

[Alexsandres]

Hi all,

I'm using Macro Visual Basic Application in Excel to send data from/to Hysys file (hsc file). I put some example how to linking between HSC file and Excel file.

Alex

[Syed Faizan Ali]

Mr. Zauderberg,
I was not able to download the 'workbook dump.zip' file from you rprevious post.
Please assist me with it if the file needs to be uploaded again.
Thanks,
Ragards,
Faizan.

[hshethna]

From Version V7.2 onwards - you can go to WorkBook | Tools | Export feature.
It will export the contents of the WorkBook to Excel. In V7.3 it is even better. No gimmicks. It is very simple and works very well.