Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
TestExcel.xlsx | 2013-08-05 | 22.1 kB | |
CoolProp_x64.dll | 2013-08-05 | 2.4 MB | |
README.rst | 2013-08-05 | 1.2 kB | |
CoolProp.xlam | 2013-08-05 | 29.4 kB | |
CoolProp.xla | 2013-08-05 | 33.8 kB | |
CoolProp.h | 2013-08-05 | 8.6 kB | |
CoolProp.dll | 2013-08-05 | 1.7 MB | |
Totals: 7 Items | 4.2 MB | 11 |
CoolProp for Excel
Ian Bell, 2012, ian.h.bell@gmail.com
Installation
(for Excel 2010, though other versions follow a similar protocol)
Part 1:
- Copy the file CoolProp.dll to c:\CoolProp folder if you have 32-bit Excel, the CoolProp_x64.dll if you have 64-bit Excel. It can't hurt to copy both if you don't know which version you have.
Part 2:
- Open Excel
- Go to the menu File-->Options-->Add-Ins
- At the bottom, select Manage: Excel Add-ins, then click the Go.. button
- Click the browse button
- Browse to the file CoolProp.xlam you downloaded, select it
- Make sure the CoolProp Add-in is selected.
- Open the file TestExcel.xlsx and try to re-evaluate one of the cells - they should work now
Part 3 (optional):
- If you have REFPROP installed, make sure you have a copy of REFPROP installed in c:\Program Files\REFPROP, if not, copy your REFPROP to this location. Alternatively you can also modify the paths in the TestExcel.xlam file
Notes
The DLL is built using the __stdcall calling convention on 32-bit windows