Locked Excel sheets.

[Dewey]

I've been using J. Lolling's components to read Excel sheets that contain locks. This works fine for earlier versions of Excel. Now I need to read newer sheets with locks and J's components don't seem to handle the new format and the default 7.0.1 Community edition Excel components don't work.

What are others doing?

[Anonymous]

Hello,

 From this page https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%..., talend v 7.0.1 is not list in the compatibility column.

Feel free to contact the author J. Lolling or leave your comments in Reviews.

Best regards

Sabrina

[Dewey · Accepted solution]

I created a Talend job that does this. 

http://blog.bitcollectors.com/adam/2011/10/how-to-unprotect-a-password-protected-xlsx-file/comment-p...