How to select several (or all ) sheets in workbook

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to select several (or all ) sheets in workbook

Alex Broytman


Hello,


I am using poi 3.17. Is there a way in POI to set several sheets active - equivalent to clicking on tabs for several sheets while holding CTRL key (or to right clicking on Sheet tab and selecting 'Select All' from pop-up menu) ?

Thanks

----------------------------------------------------------------
Alex Broytman
(212)310-7036



=========================================================================================================


<<<< Disclaimer >>>>

This message, including all attachments, is private and confidential, may contain proprietary or privileged information and material and is intended solely for use by the named addressee(s). If you receive this transmission in error, please immediately notify the sender and destroy this message in its entirety, whether in electronic or hard copy format. Any unauthorized use (and reliance thereon), copying, disclosure, retention, or distribution of this transmission or the material herein is forbidden. We reserve the right to retain, monitor, intercept and archive electronic communications. This message does not constitute an offer or solicitation with respect to the purchase or sale of any security. It should not be construed to contain any recommendation regarding any security or strategy unless expressly stated therein. Any reference to the terms of executed transactions should be treated as preliminary only and subject to formal written confirmation. Any views expressed are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This message is provided on an “as is” basis. It contains material that is owned by Instinet Incorporated, its subsidiaries or its or their licensors, and may not, in whole or in part, be (i) copied, photocopied or duplicated in any form, by any means, or (ii) redistributed, posted, published, excerpted, or quoted without Instinet Incorporated's prior written consent. No confidentiality or privilege is waived or lost by any mistransmission of this message. Instinet, LLC (member SIPC) and Instinet Canada Limited (member IIROC/CIPF) are subsidiaries of Instinet Incorporated that are locally registered or otherwise authorized to provide securities brokerage products and services. Please refer to the following links for additional disclosures and disclaimers that apply to this message. In the United States: http://instinet.com/docs/legal/le_disclaimers.html. In Canada: http://www.instinet.com/docs/legal/le_ca_disclosures.html. Effective July 1, 2014, Canada introduced Canadian Anti-Spam Legislation ("CASL"). As a Canadian resident you are receiving this electronic communication because of your existing relationship with Instinet Canada Limited or an authorized affiliate. Canadian residents who wish to unsubscribe from commercial electronic messages: please e-mail [hidden email]. Please note that you will continue to receive non-commercial electronic messages, such as account statements, invoices, client communications, and other similar factual electronic communications.



=========================================================================================================

Reply | Threaded
Open this post in threaded view
|

Re: How to select several (or all ) sheets in workbook

Dominik Stadler
Take a look at Sheet.setSelected()
<https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Sheet.html#setSelected-boolean->
:

    /**
     * Sets a flag indicating whether this sheet is selected.<p>
     *
     * Note: multiple sheets can be selected, but only one sheet can be
active at one time.
     *
     * @param value <code>true</code> if this sheet is selected
     * @see Workbook#setActiveSheet(int)
     */
    void setSelected(boolean value);

Dominik.


On Mon, Oct 29, 2018 at 6:06 PM <[hidden email]> wrote:

>
> Hello,
>
> I am using poi 3.17. Is there a way in POI to set several sheets active -
> equivalent to clicking on tabs for several sheets while holding CTRL key
> (or to right clicking on Sheet tab and selecting 'Select All' from pop-up
> menu) ?
>
> Thanks
>
> ----------------------------------------------------------------
> *Alex Broytman*
> (212)310-7036
>
>
>
> =========================================================================================================
>
> *<<<< Disclaimer >>>>*
>
> This message, including all attachments, is private and confidential, may
> contain proprietary or privileged information and material and is intended
> solely for use by the named addressee(s). If you receive this transmission
> in error, please immediately notify the sender and destroy this message in
> its entirety, whether in electronic or hard copy format. Any unauthorized
> use (and reliance thereon), copying, disclosure, retention, or distribution
> of this transmission or the material herein is forbidden. We reserve the
> right to retain, monitor, intercept and archive electronic communications.
> This message does not constitute an offer or solicitation with respect to
> the purchase or sale of any security. It should not be construed to contain
> any recommendation regarding any security or strategy unless expressly
> stated therein. Any reference to the terms of executed transactions should
> be treated as preliminary only and subject to formal written confirmation.
> Any views expressed are those of the individual sender, except where the
> message states otherwise and the sender is authorized to state them to be
> the views of any such entity. This message is provided on an “as is” basis.
> It contains material that is owned by Instinet Incorporated, its
> subsidiaries or its or their licensors, and may not, in whole or in part,
> be (i) copied, photocopied or duplicated in any form, by any means, or (ii)
> redistributed, posted, published, excerpted, or quoted without Instinet
> Incorporated's prior written consent. No confidentiality or privilege is
> waived or lost by any mistransmission of this message. Instinet, LLC
> (member SIPC) and Instinet Canada Limited (member IIROC/CIPF) are
> subsidiaries of Instinet Incorporated that are locally registered or
> otherwise authorized to provide securities brokerage products and services.
> Please refer to the following links for additional disclosures and
> disclaimers that apply to this message. In the United States:
> http://instinet.com/docs/legal/le_disclaimers.html. In Canada:
> http://www.instinet.com/docs/legal/le_ca_disclosures.html. Effective July
> 1, 2014, Canada introduced Canadian Anti-Spam Legislation ("CASL"). As a
> Canadian resident you are receiving this electronic communication because
> of your existing relationship with Instinet Canada Limited or an authorized
> affiliate. Canadian residents who wish to unsubscribe from commercial
> electronic messages: please e-mail [hidden email]. Please
> note that you will continue to receive non-commercial electronic messages,
> such as account statements, invoices, client communications, and other
> similar factual electronic communications.
>
>
>
>
> =========================================================================================================
>