Apparently, EasyMorph can’t load password-protected Excel workbooks at this point.
I did a bit of research – it’s possible to remove/disable the password using a VBA macro. The macro can reside in another workbook, which gets executed from the command line [hint].
Alternatively, this can be done using a PowerShell script, something like that (not tested!):
$excel = new-object -comobject excel.application
$workbook = $excel.workbooks.open("C:\myfile.xls",0,$False,1,"password")
$workbook.Password = ""
$workbook.save()
$workbook.close()
$excel.quit()
In v3.7 there is the PowerShell transformation that can be used for running PowerShell commands. Or simply run a script from command line using “RunProgram” and PowerShell executable.
Once the password is removed the workbook can be loaded in EasyMorph in a regular way.