You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by DrDad <dr...@bellatlantic.net> on 2011/07/01 21:51:49 UTC
WindowOneRecord in XSSF??
I can't find an equivalent or even a simulacrum of WindowOneRecord for XSSF.
The Excel 2007 Object model contains a Window object that does just what I'm
looking for. How can I get one into a XSSFWorkbook??
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/WindowOneRecord-in-XSSF-tp4543137p4543137.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: WindowOneRecord in XSSF??
Posted by Yegor Kozlov <ye...@dinom.ru>.
You want to examine the XSSFWorkbook().getCTWorkbook().getBookViews()
collection.
The schema for CTBookView (section 3.2.30 in the spec) is as follows:
<complexType name="CT_BookView">
<sequence>
<element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
</sequence>
<attribute name="visibility" type="ST_Visibility" use="optional"
default="visible"/>
<attribute name="minimized" type="xsd:boolean" use="optional" default="false"/>
<attribute name="showHorizontalScroll" type="xsd:boolean"
use="optional" default="true"/>
<attribute name="showVerticalScroll" type="xsd:boolean"
use="optional" default="true"/>
<attribute name="showSheetTabs" type="xsd:boolean" use="optional"
default="true"/>
<attribute name="xWindow" type="xsd:int" use="optional"/>
<attribute name="yWindow" type="xsd:int" use="optional"/>
<attribute name="windowWidth" type="xsd:unsignedInt" use="optional"/>
<attribute name="windowHeight" type="xsd:unsignedInt" use="optional"/>
<attribute name="tabRatio" type="xsd:unsignedInt" use="optional"
default="600"/>
<attribute name="firstSheet" type="xsd:unsignedInt" use="optional"
default="0"/>
<attribute name="activeTab" type="xsd:unsignedInt" use="optional" default="0"/>
<attribute name="autoFilterDateGrouping" type="xsd:boolean"
use="optional" default="true"/>
</complexType>
Yegor
On Fri, Jul 1, 2011 at 11:51 PM, DrDad <dr...@bellatlantic.net> wrote:
> I can't find an equivalent or even a simulacrum of WindowOneRecord for XSSF.
> The Excel 2007 Object model contains a Window object that does just what I'm
> looking for. How can I get one into a XSSFWorkbook??
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/WindowOneRecord-in-XSSF-tp4543137p4543137.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org