This may well sound completely stupid but have you tried using a template file yet? It may - and that is a big may - be possible to use Excel to create a template file that is password protected. Then you could open that file using POI, populate it with data and re-save it away again. I know that POI passes through anything that it does not recognise and it may well do the same with this sort of tempate file. If I have the chance later, I will try it myself to see what happens, after all, what can we lose?
Yours Mark B PS, the bit of the SpreadsheetML that Yegor is talking about contains the password for the file but it has been encrypted in some manner. In fact, it looks something like this; <sheetProtection password="83AF" sheet="1" objects="1" scenarios="1" formatCells="0" /> where the string 83AF is the password 'password' after encryption. The best thing you could do would be to conduct some research to find out if you could identify the encryption algorithm. That sort of information may/will help the developers to more rapidly address this issue. Bugzilla from [email protected] wrote: > > https://issues.apache.org/bugzilla/show_bug.cgi?id=48900 > > --- Comment #2 from [email protected] 2010-03-15 15:29:19 UTC --- > (In reply to comment #1) >> Please don't abuse Bugzilla. Changing the priority of a bug to Blocker >> will not >> help us to fix it sooner. >> If you are really interested in fixing this issue - you are welcome to do >> a >> research and figure out which bits of the SpreadsheetML are missing. If >> you >> need a >> guidance, please ask, I will be happy to help. >> Yegor > > > Hey Yegor, > > we have the same method sheet.protectSheet("qq"); in the HSSF API and i > need > the same for XSSF API. > > Let me know if there is any workaround in XSSF API to protect worksheet > with a > password. > > This a kind of show stopper for my project currently. Any help is > appreciated. > > Thanks, > Vivek > > -- > Configure bugmail: > https://issues.apache.org/bugzilla/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You are the assignee for the bug. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-48900--New%3A-XSSF-doesn%27t-have-the-method-protectSheet-as-we-have-for-HSSF-API-tp27878972p27907020.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
