Is it possible to create encrypted HSSF workbooks?

2011-06-01 Thread Alex Broytman
Hello, our application needs to be able create encrypted (password protected) workbooks using POI HSSF. We can read encrypted workbooks, but is creation of such workbooks supported? Thanks - To unsubscribe, e-mail: user-unsub

Creating encrypted workbooks using HSSF

2011-06-02 Thread Alex . Broytman
Hello, we have a requirement to create encrypted workbooks (so that user is asked for the password when he opens workbook in Excel) and we use POI HSSF. We can read workbooks that are already encrypted using Biff8EncryptionKey .setCurrentUserPassword(), but it does not affect workbooks we creat

Re: Creating encrypted workbooks using HSSF

2011-06-02 Thread Alex Broytman
Instinet.com> writes: Please disregard, Sorry for posting the same question again - did not realize that this is the same mailing list. - To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-m

RE: Excel file protection using Apache POI

2012-01-10 Thread Alex . Broytman
I think Aspose provides this feature (www.aspose.com). This is commercial software, though |> | From: | |> >

Image from worksheet does not get cloned

2012-11-26 Thread Alex Broytman
Hello, I have a simple template 'xls' file which contains one worksheet with an image. I need to clone this sheet. As a result my new sheet gets the image, but the image disappers from original sheet - instead Excel shows me just a placeholder with message 'This image cannot currently be displa

Re: Image from worksheet does not get cloned

2012-11-26 Thread Alex Broytman
This worked, thanks a lot Yegor Kozlov dinom.ru> writes: > > Please try with the latest build from trunk. Many bugs including > support for images in HSSF have been fixed since POI-3.8 > > Yegor > - To unsubscribe, e-mail:

problem with shiftRows for XSSF

2016-05-29 Thread Alex Broytman
Hi, I am using poi v 3.14. My program reads a spreadsheet (which has just two cells filled for the sake of this simple test) , fills rows and then needs to swap rows. It works fine when template is in "xls" format and so is the output. However, when template is saved as "xlsx", then resulting x

Question: Problem with Encryption in POI

2018-06-12 Thread Alex . Broytman
e(); OutputStream fos = new FileOutputStream(new File("./f.xlsx")); fs.writeFilesystem(fos); fos.close(); } catch (Exception ex) { System.out.println(ex.getMessage()); ex.printStackTrace(); } } -

How to select several (or all ) sheets in workbook

2018-10-29 Thread Alex . Broytman
? Thanks ---- Alex Broytman (212)310-7036 = <<<< Disclaimer >>>> This message, including all attachments, is private and confidential, may contain proprie