You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Nina <sn...@gmail.com> on 2011/09/14 10:04:10 UTC
Extract embedded content in .xlsx files using xssf eventusermodel
Hi,
I would like to use xssf Eventusermodel to get all embedded content in .xlsx
file.
Should i first get all sheetparts or the parts of OPCPackage container?
Getting sheetpart doesnt seem to help :(...Could anybody provide a sample
code for the same?
The apache site has sample code only for xssf usermodel :( Kindly helppp
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Extract-embedded-content-in-xlsx-files-using-xssf-eventusermodel-tp4801954p4801954.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: Extract embedded content in .xlsx files using xssf
eventusermodel
Posted by Nick Burch <ni...@alfresco.com>.
On Wed, 14 Sep 2011, Nina wrote:
> I would like to use xssf Eventusermodel to get all embedded content in
> .xlsx file. Should i first get all sheetparts or the parts of OPCPackage
> container?
Yes. Embedded content is normally stored as a relation from the sheet
parts. So, open the container, get the workbook part, and then get the
sheet parts from that. For each sheet part, get the relations, and check
to see if any are of a type that interests you (i.e. are embedded
contents). Process those ones you find
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org