Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: domain of denis.delangle.ml@gmail.com
 designates 74.125.82.174 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAAwi-j_WPLwPtWkgP=7KbsuPz6fH_kkBKCR6fqL43QwzVfoh6w@mail.gmail.com>
References: 
 <CAOvrZ1jPsApofY6U7fJMoLmNOJ13s4zCgdapuGCf8cnHXCh1hQ@mail.gmail.com>
	<CAAwi-j_aTfqERM0r4CfiZfCoTj=S5muzP9e3TspNY_jqCqyxMQ@mail.gmail.com>
	<CAOvrZ1jB6MN2hQopRTRt1vXyCF7q-MvhBC7sM2VwcmqK__jvXg@mail.gmail.com>
	<CAAwi-j_WPLwPtWkgP=7KbsuPz6fH_kkBKCR6fqL43QwzVfoh6w@mail.gmail.com>
Date: Wed, 20 Jun 2012 13:07:18 +0200
Message-ID: 
 <CAOvrZ1gRQmxUPxzQ_MUJqnsuCL06MPY9huzWvsy3AQRgZyamvQ@mail.gmail.com>
Subject: Re: Excel 97 - How to get get text zones from a Sheet
From: Denis Delangle <denis.delangle.ml@gmail.com>
To: POI Users List <user@poi.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Ok thanks

2012/6/20 Yegor Kozlov <yegor.kozlov@dinom.ru>:
> The text is empty becase HSSF does not fully read existing drawing
> objects from sheets. POI can create new drawings from scratch but
> cannotfully =A0read and modify existing ones.
> =A0It is an old and known limitation and we are working to improve this
> area, but for now you can only read basic shape properties.
>
>
> Yegor
>
> On Wed, Jun 20, 2012 at 2:06 PM, Denis Delangle
> <denis.delangle.ml@gmail.com> wrote:
>> Thanks for your quick answer,
>>
>> I tried this code with this file =A0:
>> for(HSSFShape shape : wb.getSheetAt(1).getDrawingPatriarch().getChildren=
()) {
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0System.out.println(">> " =
+ shape.toString());
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0if(shape instanceof HSSFT=
extbox) {
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0HSSFTextb=
ox txtBox =3D (HSSFTextbox) shape;
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0System.ou=
t.println("-- "+txtBox.getString().length() +
>> txtBox.getString().toString());
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0}
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0}
>>
>> But the text is always empty :
>>>> org.apache.poi.hssf.usermodel.HSSFTextbox@61542a75
>> -- 0
>>
>> Any idea why ?
>>
>> Denis
>>
>> 2012/6/20 Yegor Kozlov <yegor.kozlov@dinom.ru>:
>>> Try to iterate over shapes in sheet.getDrawingPatriarch().getChildren()=
.
>>> Check if a object is HSSFTextbox and then retrive its position via
>>> shape.getAnchor().
>>>
>>> Yegor
>>>
>>> On Wed, Jun 20, 2012 at 12:21 PM, Denis Delangle
>>> <denis.delangle.ml@gmail.com> wrote:
>>>> Hello,
>>>>
>>>> First of all I am an happy user of POI (using it intensively during
>>>> last 2 years on various Excel files to extract data) stuck for the
>>>> first time. So thanks for this nice peace of software.
>>>>
>>>> I would like to extract text zones from my Excel file but I really
>>>> need to know to which sheet the text zone belongs to.
>>>>
>>>> I tried this method to get all the text zones from a workbook using
>>>> TextObjectRecord and HSSFRequest :
>>>> http://article.gmane.org/gmane.comp.jakarta.poi.user/8549/match=3Dtext=
objectrecord
>>>> But I don't have sheet information.
>>>>
>>>> Do you know if there is a way to get it ?
>>>>
>>>> Regards,
>>>>
>>>> Denis
>>>>
>>>> ---------------------------------------------------------------------
>>>> 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
>>>
>>
>>
>> ---------------------------------------------------------------------
>> 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
>

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