Jump to content

  • Log in with Facebook Log In with Google      Sign In   
  • Create Account


ChExpress Blog - 12/17/14

Read the latest news from the chemical industry in Christa's blog.

Featured Articles

Check out the latest featured articles.

File Library

Check out the latest downloads available in the File Library.

New Article

Product Viscosity vs. Shear

Featured File

Multiphase Slug Length and Volume Calculator

How To Export Hysys Case To Ms Excel


This topic has been archived. This means that you cannot reply to this topic.
14 replies to this topic
Share this topic:

#1 Padmakar Katre

Padmakar Katre

    Gold Member

  • ChE Plus Subscriber
  • 911 posts

Posted 02 March 2008 - 02:30 AM

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.

#2 Zauberberg

Zauberberg

    Gold Member

  • Store Customers
  • 2,197 posts

Posted 02 March 2008 - 09:07 AM

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]

#3 Padmakar Katre

Padmakar Katre

    Gold Member

  • ChE Plus Subscriber
  • 911 posts

Posted 02 March 2008 - 10:00 AM

Dear,
Thanks it will do for me.

#4 nicolasbrunner

nicolasbrunner

    Brand New Member

  • Members
  • 1 posts

Posted 20 March 2008 - 11:08 AM

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 ?

#5 joerd

joerd

    Gold Member

  • ChE Plus Subscriber
  • 371 posts

Posted 20 March 2008 - 12:46 PM

QUOTE (nicolasbrunner @ Mar 20 2008, 09:08 AM) <{POST_SNAPBACK}>
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!

#6 JoeWong

JoeWong

    Gold Member

  • ChE Plus Subscriber
  • 1,223 posts

Posted 20 March 2008 - 04:44 PM

QUOTE (joerd @ Mar 20 2008, 01:46 PM) <{POST_SNAPBACK}>
QUOTE (nicolasbrunner @ Mar 20 2008, 09:08 AM) <{POST_SNAPBACK}>
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...

#7 joerd

joerd

    Gold Member

  • ChE Plus Subscriber
  • 371 posts

Posted 21 March 2008 - 11:37 AM

QUOTE
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.

#8 petro08

petro08

    Brand New Member

  • Members
  • 1 posts

Posted 03 December 2008 - 01:06 PM

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

#9 Alex Krenvalk

Alex Krenvalk

    Brand New Member

  • Members
  • 2 posts

Posted 08 January 2009 - 10:57 AM

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.



#10 suhas

suhas

    Veteran Member

  • Members
  • 33 posts

Posted 28 March 2009 - 05:58 AM

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

#11 wamit

wamit

    Junior Member

  • Members
  • 12 posts

Posted 12 April 2009 - 05:29 PM

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

#12 Hysysadvisor

Hysysadvisor

    Brand New Member

  • Members
  • 2 posts

Posted 30 May 2011 - 11:21 AM

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?


#13 Alexsandres

Alexsandres

    Junior Member

  • Members
  • 21 posts

Posted 15 June 2011 - 09:39 AM

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

#14 Syed Faizan Ali

Syed Faizan Ali

    Brand New Member

  • Members
  • 4 posts

Posted 25 August 2011 - 01:56 AM

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.

#15 hshethna

hshethna

    Junior Member

  • Members
  • 17 posts

Posted 02 September 2011 - 12:45 PM

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.




Similar Topics