How to select several (or all ) sheets in workbook

[A***@Instinet.com]

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
[phone]
========================================================================================================= <<<< 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 ***@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.

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

[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.

Post by A***@Instinet.com
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*
[phone]
=========================================================================================================
*<<<< 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
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
note that you will continue to receive non-commercial electronic messages,
such as account statements, invoices, client communications, and other
similar factual electronic communications.
=========================================================================================================