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:

grate/xls/crypto/rc4.go

Line 121 in 3f8e65d

d.SetPassword([]byte(DefaultXLSPassword))

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