poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Blake Watson <blake.wat...@pnmac.com>
Subject Re: Internal Sheet Name?
Date Thu, 26 May 2016 21:22:56 GMT
>> XSSF or HSSF?

XSSF

>> If XSSF, have you looked inside the XML files to see if the internal
name is there?

When I fetch a worksheet, an inspection of the resultant object will look
something like this:

#object[org.apache.poi.xssf.usermodel.XSSFSheet
        0x129ddaa
        "Name: /xl/worksheets/sheet1.xml - Content Type:
application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"]

And if I open up the xlsx directly, I see "sheet1" in there, although I
=don't= see it in the results of getCTWorksheet.

But I was mostly trying to figure out if there were a particular
function/field for it.


On Wed, May 25, 2016 at 6:37 PM, Javen O'Neal <javenoneal@gmail.com> wrote:

> XSSF or HSSF? If XSSF, have you looked inside the XML files to see if the
> internal name is there?
> On May 25, 2016 3:24 PM, "Blake Watson" <blake.watson@pnmac.com> wrote:
>
> > Is it possible to get the "(Name)" attribute of a sheet (rather than the
> > "Name" attribute)? That is, using the "Balloon Payment Loan" calculator,
> > there's a sheet called "BALLOON PAYMENT LOAN", but if you open up VBA,
> you
> > see the tree of objects, with one called "Sheet2 (BALLOON PAYMENT LOAN)".
> >
> > Can I get the "Sheet2" attribute, whatever it's called?
> > --
> >
> > *Blake Watson*
> >
> > *PNMAC*
> > Application Development Manager
> > 5898 Condor Drive
> > Moorpark, CA 93021
> > (805) 330.4911 x7742
> > blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
> > www.PennyMacUSA.com <http://www.pennymacusa.com/>
> >
>



-- 

*Blake Watson*

*PNMAC*
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742
blake.watson@pnmac.com <melanie.petrosyan@pnmac.com>
www.PennyMacUSA.com <http://www.pennymacusa.com/>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message