You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Artem Telizhenko <bi...@gmail.com> on 2017/04/05 15:07:11 UTC
Prevent of creation new sheets
Hi,
I am tried to find out functionality to prevent creation new sheets.
So in my case i need to prevent to create new sheets after saving to Excel.
In VBA it resolve something like as "ThisWorkBook.Protect Structure:=True".
Could you tell me, how to do it in poi?
Thanks.
Best regatds,
Artem Telizhenko
Re: Prevent of creation new sheets
Posted by Blake Watson <bl...@pnmac.com>.
I've never done it but I think it might be "LockStructure",
On Wed, Apr 5, 2017 at 8:57 AM, Murphy, Mark <mu...@metalexmfg.com>
wrote:
> How about just don't create a new sheet. Saving does not create new sheets
> in POI.
>
> -----Original Message-----
> From: Artem Telizhenko [mailto:bito4ek91@gmail.com]
> Sent: Wednesday, April 05, 2017 11:07 AM
> To: user@poi.apache.org
> Subject: Prevent of creation new sheets
>
> Hi,
> I am tried to find out functionality to prevent creation new sheets.
> So in my case i need to prevent to create new sheets after saving to Excel.
> In VBA it resolve something like as "ThisWorkBook.Protect Structure:=True".
> Could you tell me, how to do it in poi?
>
> Thanks.
>
> Best regatds,
> Artem Telizhenko
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
--
*Blake Watson*
*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <me...@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>
RE: Prevent of creation new sheets
Posted by "Murphy, Mark" <mu...@metalexmfg.com>.
How about just don't create a new sheet. Saving does not create new sheets in POI.
-----Original Message-----
From: Artem Telizhenko [mailto:bito4ek91@gmail.com]
Sent: Wednesday, April 05, 2017 11:07 AM
To: user@poi.apache.org
Subject: Prevent of creation new sheets
Hi,
I am tried to find out functionality to prevent creation new sheets.
So in my case i need to prevent to create new sheets after saving to Excel.
In VBA it resolve something like as "ThisWorkBook.Protect Structure:=True".
Could you tell me, how to do it in poi?
Thanks.
Best regatds,
Artem Telizhenko
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org