unable to open password protected .xls file

[bsudheer]

unable to process password protected .xls file. How can we enhance the xls.go open function to pass password as params and use the same while reading data from workbook

[pbnjay]

I believe you just need a way to pass the password into the rc4 implementation at this point: https://github.com/pbnjay/grate/blob/3f8e65d74a1479a5ab13eebde36560773d518676/xls/crypto/rc4.go#L121

eg replacing the built-in default protection password with the user facing one.

if you want to do a PR let me know and we can work together on a public facing API that will work for xlsx also