I have an excel spreadsheet that was designed to be a form where you can plug-in some
values and it will calculate costs based on the formula, it takes about 30 different parameters.
I can open this form, enter values and get a result without entering password (both manually
and in Java). I don't have access to the formula.
While I'm not sure either way, there are indications that jExcelApi can be used to unlock Excel spreadsheets without having the password. That may be worth a try; let us know how you make out if you do.
i'll be very glad if someone can give us a solution to this problem.
I have the password of the excel document, but dont know how to open it.
Thanks a lot,
Joined: Mar 22, 2005
Sergio, did you read (and act on) my previous post?
Joined: Jul 30, 2009
yes, i read it and try,but dont works.
My excel document is sheet protected and book protected.
i've got the same exception (jxl.read.biff.PasswordException: The workbook is password protected) in the first line: Workbook workbook = Workbook.getWorkbook(new File("/path/to/protected.xls"));
Joined: Jul 20, 2009
Thank you for your replies. My problem was solved by testing my code on our server.
On my development machine my code would take about 7 seconds. On server it
is 0.7 seconds. So I don't have a problem anymore (can somebody recommend
good profiling tool? I want to figure out what exactly is going on.)
For the guys that have problem accessing password protected Excel sheets.
With e-Spreadsheet from Actuate. http://www.actuate.com/products/e-spreadsheet/ I don't have to enter the password. I can open the spreadsheet that I'm working with,
enter values and get results just by opening it in Excel. I'm not sure how e-Spreadsheet does
it but I can set cells that I need for calculation and I can read the results from result cells.