Android Question Open excel workbook protected with password

suncand

New Member
Licensed User
Longtime User
Hi , i´m using excel library, but I can´t open a excel workbook protected with password. Is possible open excel protected? . Anyone can put me a sample if is possible please.

thanks!!
 
Last edited:

suncand

New Member
Licensed User
Longtime User
Hi, this is my Log error. How I can put the password??. I tried with:

bookExcel1.Encoding="mypasword"

before initialize the bookexcel, but i´m not sure that i´m doing. Don´t work :(



LOG

jxl.read.biff.PasswordException: The workbook is password protected
** Activity (main) Pause, UserClosed = true **
** Activity (main) Resume **
Installing file.
** Activity (main) Pause, UserClosed = false **
PackageAdded: package:myapp
** Activity (main) Create, isFirst = true **
(Main, 248) FullScreen or IncludeTitle properties in layout file do not match the activity attributes settings. (warning #1004)
jxl.read.biff.PasswordException: The workbook is password protected
at jxl.read.biff.WorkbookParser.parse(WorkbookParser.java:589)
at jxl.Workbook.getWorkbook(Workbook.java:271)
at anywheresoftware.b4a.objects.WorkbookWrapper.Initialize(WorkbookWrapper.java:60)
at myapp.main._activity_create(main.java:450)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:173)
at myapp.main.afterFirstLayout(main.java:98)
at myapp.main.access$100(main.java:16)
at myapp.main$WaitForLayout.run(main.java:76)
at android.os.Handler.handleCallback(Handler.java:615)
at android.os.Handler.dispatchMessage(Handler.java:92)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:4905)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:511)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:790)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
at dalvik.system.NativeStart.main(Native Method)

jxl.read.biff.PasswordException: The workbook is password protected

** Activity (main) Resume **
 
Upvote 0
Top