You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Fulg de Nea <fu...@yahoo.com> on 2007/03/28 18:05:50 UTC
Protecting excel columns
Hi guys,
I was wondering if it is possible to protect the excel
worksheets.. for example to set some cells not to be
editable. If this can be done, please tell me in which
POI version.
Best regards,
Rodica
____________________________________________________________________________________
Don't get soaked. Take a quick peek at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Protecting excel columns
Posted by Fulg de Nea <fu...@yahoo.com>.
I will try this way. Thanks for your answer.
Rodica
--- s k <si...@gmail.com> wrote:
> I use POI 2.5.1. It works fine.
> I did 3 things.
> 1. Create cell style and set lock, see:
> cellStyle.setLocked(boolean)
> 2. Set cell style to a cell e.g.
> cell.setCellStyle(cellStyle);
> 3. Protect your worksheet e.g.
> sheet1.setProtect(true);
>
> S K
>
> On 3/28/07, Fulg de Nea <fu...@yahoo.com> wrote:
> > Hi guys,
> >
> > I was wondering if it is possible to protect the
> excel
> > worksheets.. for example to set some cells not to
> be
> > editable. If this can be done, please tell me in
> which
> > POI version.
> >
> > Best regards,
> > Rodica
____________________________________________________________________________________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Protecting excel columns
Posted by s k <si...@gmail.com>.
I use POI 2.5.1. It works fine.
I did 3 things.
1. Create cell style and set lock, see: cellStyle.setLocked(boolean)
2. Set cell style to a cell e.g. cell.setCellStyle(cellStyle);
3. Protect your worksheet e.g. sheet1.setProtect(true);
S K
On 3/28/07, Fulg de Nea <fu...@yahoo.com> wrote:
> Hi guys,
>
> I was wondering if it is possible to protect the excel
> worksheets.. for example to set some cells not to be
> editable. If this can be done, please tell me in which
> POI version.
>
> Best regards,
> Rodica
>
>
>
> ____________________________________________________________________________________
> Don't get soaked. Take a quick peek at the forecast
> with the Yahoo! Search weather shortcut.
> http://tools.search.yahoo.com/shortcuts/#loc_weather
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/