poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "F. Da Costa Gomez" <dacostago...@gmail.com>
Subject Re: Parsing single sheets using the HSSF event API
Date Thu, 08 Apr 2010 09:32:20 GMT
Hi,
I'v done something similar some while ago and posted te resulting class on the list ..
Might be handy to have a look.

Cheers,
F DCG
Sent from my BlackBerry® smartphone

-----Original Message-----
From: Andreas Hartmann <andreas@apache.org>
Date: Thu, 08 Apr 2010 10:50:59 
To: <user@poi.apache.org>
Subject: Re: Parsing single sheets using the HSSF event API

Am 07.04.10 16:22, schrieb Andreas Hartmann:
> is it possible to parse only a single sheet in a workbook using the
> event API? I want to do something like this:
>
> * Detect the sheets using BoundSheetRecords
> * Let the user select a sheet
> * Import data from this sheet

I figured out a way:

* Determine the position of the sheet (occurence of the BoundSheetRecord)
* Handle row records with row=0 to detect sheet starting points and 
enable/disable parsing accordingly

Is this a safe way to accomplish this task?

Thanks for any comments!

-- Andreas


-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Mime
View raw message