These are not really technical issues just suggestions.
- I am using Win 8.1 64-bit. If I use the msi installer the modules are all installed to the SysWOW64 folder, even though the file dialog provides the system32 folder. Not a real problem, just an inconvenience as it took a few minutes to work out what was
going on when nothing showed up with the get-module. I just copied the files to the "user\documents\windows powershell\modules\excelpslib" folder.
- The path to the dll is hard wired to the install folder in ExcelPSLib.psm1. A better approach is to use relative paths. I simply edited the following line in ExcelPSLib.psd1.
# Assemblies that must be loaded prior to importing this module
RequiredAssemblies = @('EPPlus.dll')
and deletedt the following lines in ExcelPSLib.psm1.
$DLLPath = "C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ExcelPSLib\EPPlus.dll"
# Load The .Net Library EPPLUS
[Reflection.Assembly]::LoadFile($DLLPath) | Out-Null
After doing the above the demo.ps1 worked like a charm.