You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Jan Stette <ja...@gmail.com> on 2010/04/22 14:17:56 UTC

Getting metadata from XSSF workbook

Hi,

when accessing an HSSF workbook, I can get metadata for the workbook such as
author and last modification date from the SummaryInformation object.  How
do I get the equivalent fields for an XSSF workbook?

I've looked at the examples and googled around for this; so far I've found
that Workbook.getExtendedProperties() method and the
getUnderlyingProperties() on the the extended properties, but I can't find
any methods for things like author, creation time or modification time.  Any
ideas?

Regards,
Jan

Re: Getting metadata from XSSF workbook

Posted by Jan Stette <ja...@gmail.com>.
That looks promising, I'll give that a go, thanks.

Jan


On 22 April 2010 16:18, MSB <ma...@tiscali.co.uk> wrote:

>
> Hello Jan,
>
> Not too sure if this is what you need but I saw an answer Nick gave to a
> similar question regarding an XWPF document;
>
>
> http://svn.apache.org/repos/asf/poi/trunk/src/ooxml/java/org/apache/poi/POIXMLPropertiesTextExtractor.java
>
> Give it a go and see what happens, but I cannot promise anything as I have
> never tried it myself.
>
> Yours
>
> Mark B
>
>
> Jan Stette-2 wrote:
> >
> > Hi,
> >
> > when accessing an HSSF workbook, I can get metadata for the workbook such
> > as
> > author and last modification date from the SummaryInformation object.
>  How
> > do I get the equivalent fields for an XSSF workbook?
> >
> > I've looked at the examples and googled around for this; so far I've
> found
> > that Workbook.getExtendedProperties() method and the
> > getUnderlyingProperties() on the the extended properties, but I can't
> find
> > any methods for things like author, creation time or modification time.
> > Any
> > ideas?
> >
> > Regards,
> > Jan
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/Getting-metadata-from-XSSF-workbook-tp28328333p28330358.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: Getting metadata from XSSF workbook

Posted by MSB <ma...@tiscali.co.uk>.
Hello Jan,

Not too sure if this is what you need but I saw an answer Nick gave to a
similar question regarding an XWPF document;

http://svn.apache.org/repos/asf/poi/trunk/src/ooxml/java/org/apache/poi/POIXMLPropertiesTextExtractor.java

Give it a go and see what happens, but I cannot promise anything as I have
never tried it myself.

Yours

Mark B


Jan Stette-2 wrote:
> 
> Hi,
> 
> when accessing an HSSF workbook, I can get metadata for the workbook such
> as
> author and last modification date from the SummaryInformation object.  How
> do I get the equivalent fields for an XSSF workbook?
> 
> I've looked at the examples and googled around for this; so far I've found
> that Workbook.getExtendedProperties() method and the
> getUnderlyingProperties() on the the extended properties, but I can't find
> any methods for things like author, creation time or modification time. 
> Any
> ideas?
> 
> Regards,
> Jan
> 
> 

-- 
View this message in context: http://old.nabble.com/Getting-metadata-from-XSSF-workbook-tp28328333p28330358.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