Up to Discussions in JExcel API
1 Replies Last post: Jul 17, 2009 5:45 PM by Serge Piletsky  
 
manoj
1 posts since
Jul 9, 2009
Currently Being Moderated

Jul 9, 2009 3:44 PM

Protecting Excel File with password using Jexcel

Hi EveryOne,

 

Is it possible to protect an excel sheet with password and using Jexcel?

If any one have any idea or worked on this area, then please reply to this discussion thread.

If not possible through Jexcel, then any other toll which could make it done?

 

Manoj

Serge Piletsky TeamDev Ltd.
Serge Piletsky
1,066 posts since
Apr 24, 2006
Currently Being Moderated
1. Jul 17, 2009 5:47 PM in response to: manoj
Re: Protecting Excel File with password using Jexcel

Hi,

 

Of course it's possible to set a password using JExcel. There is the setPassword(String) method in Workbook class for this purpose: http://www.teamdev.com/downloads/jexcel/javadoc/com/jniwrapper/win32/jexcel/GenericWorkbook.html The same method also exists in JWorkbook component.

 

It's also possible to protecte a worksheet with a password using Worksheet.protect(String) method: http://www.teamdev.com/downloads/jexcel/javadoc/com/jniwrapper/win32/jexcel/Worksheet.html#protect%28java.lang.String%29

 

-Serge

More Like This

  • Retrieving data ...