Skip to content

Instantly share code, notes, and snippets.

@junjihashimoto

junjihashimoto/setting password for xlconnect

Created September 26, 2013 07:36
Show Gist options
  • Save junjihashimoto/6710956 to your computer and use it in GitHub Desktop.
Save junjihashimoto/6710956 to your computer and use it in GitHub Desktop.
Download ZIP
How to set password for xlconnect
Raw
setting password for xlconnect
Before calling loadWorkbook, call following command.
> .jcall("org.apache.poi.hssf.record.crypto.Biff8EncryptionKey","V","setCurrentUserPassword","password")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment