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

[Dominik Stadler <do...@gmx.at>]

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 <Al...@instinet.com> 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 iclcompliance@instinet.com. 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.
>
>
>
>
> =========================================================================================================
>