Re: Doc changes, Was: Re: please help me out

2007-04-12 Thread patrick roussel

Did you get all the archives at
http://www.mirianet.com/poi/

?
Because there is a code inside and you'll be able ti display a table and its
contain


On 4/12/07, Rajeshwar Mothe <[EMAIL PROTECTED]> wrote:


hi patrick

but i want to display a table & i want to display data in it

so plzz provide some code for that ..

please

by patrick

waiting for u r reply

urs

Rajeshwar Mothe


On 4/12/07, patrick roussel <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I have made a contribution about POI project, it concerns specially
> poi/hwpf.
>
> What I made is modify org/apache/poi/hwpf/usermodel/Range.java in order
to
> make possible detection in tables that are contained in others tables
> (method "getTable()"), therefore I added two public methods :
>
> - getStartIdx
> - getEndIdx
>
> because the returned values can easily identify a paragrah by unicity in
a
> range
>
> You'll also find an archive "word2html.zip" that contains "
> jakarta-poi-full.jar" (It's contains all poi project class including
> Range.class modified) and a small program that can convert an MS Word
> document to html.
>
> All files can found there :
>
> http://www.mirianet.com/poi/
>
> Regards
>
> Patrick Roussel
>



Re: Doc changes, Was: Re: please help me out

2007-04-12 Thread Rajeshwar Mothe

hi patrick

but i want to display a table & i want to display data in it

so plzz provide some code for that ..

please

by patrick

waiting for u r reply

urs

Rajeshwar Mothe


On 4/12/07, patrick roussel <[EMAIL PROTECTED]> wrote:


Hi

I have made a contribution about POI project, it concerns specially
poi/hwpf.

What I made is modify org/apache/poi/hwpf/usermodel/Range.java in order to
make possible detection in tables that are contained in others tables
(method "getTable()"), therefore I added two public methods :

- getStartIdx
- getEndIdx

because the returned values can easily identify a paragrah by unicity in a
range

You'll also find an archive "word2html.zip" that contains "
jakarta-poi-full.jar" (It's contains all poi project class including
Range.class modified) and a small program that can convert an MS Word
document to html.

All files can found there :

http://www.mirianet.com/poi/

Regards

Patrick Roussel



Re: Doc changes, Was: Re: please help me out

2007-04-12 Thread patrick roussel

Hi

I have made a contribution about POI project, it concerns specially
poi/hwpf.

What I made is modify org/apache/poi/hwpf/usermodel/Range.java in order to
make possible detection in tables that are contained in others tables
(method "getTable()"), therefore I added two public methods :

- getStartIdx
- getEndIdx

because the returned values can easily identify a paragrah by unicity in a
range

You'll also find an archive "word2html.zip" that contains "
jakarta-poi-full.jar" (It's contains all poi project class including
Range.class modified) and a small program that can convert an MS Word
document to html.

All files can found there :

http://www.mirianet.com/poi/

Regards

Patrick Roussel


RE: What is the correct method to read a large excel file line by line?

2007-04-12 Thread Levi Strope
I just want to clarify, as my boss is asking me to look into it further.
Per the documentation is says that using the HSSF eventusermodel is much
more efficient in terms of memory.  Does this mean that I can read in an
excel document without loading the entire document into memory first?
Reading it line by line is not a requirement, but in some cases we have
files that are over 100 meg.  I need to know if I can read it in in
pieces, or iterate through the records by request without having the
entire document loaded into memory first.  Is this possible?

Thanks
-Levi 

 

-Original Message-
From: Yegor Kozlov [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 10, 2007 12:24 PM
To: POI Users List
Subject: Re: What is the correct method to read a large excel file line
by line?

Hi,

Current implementation reads the whole document into memory.
There is no way to read excel files line by line.

Regards,
Yegor

LS> Using HSSF, what is the correct method to read large excel files 
LS> line by line?
 
LS> In my real world situation the excel file will be very large, over 
LS> 100 megs.  I need to be able to read the file line by line so that 
LS> the large file size does not cause memory issues.
 
LS> I have tried to use a BufferedInputStream to read in the file but 
LS> that results in invalid header exceptions when I try to do a read().

LS> I can use the BufferedInputStream as is if I give the whole thing to

LS> the workbook to process.However this pretty much forces me to read 
LS> in the entire file at once does it not?
 
LS> If anyone has any examples, or can round about hint at what I need 
LS> to do I would be most appreciative.
 
LS> Thank you,
LS> Levi


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/



Re: Doc changes, Was: Re: please help me out

2007-04-12 Thread Rajeshwar Mothe

hi Rainer

I want to display an image into word document using HWPF

how i need to procced help me with some piece of code

thanks & regards

Rajeshwar Mothe

On 4/12/07, Rainer Schwarze <[EMAIL PROTECTED]> wrote:


At 05:20 12.04.2007, Rainer Klute wrote:
>If this question is asked every now and then it is worth to be answered
>before the question is raised. This saved you and the user some effort -
>not to mention those users that won't ask but simply think that HWPF
>isn't useful and look for an alternative. And I wouldn't call the
>question "What HWPF cannot do" but rather "How to create a new Word
>document".

Hi,

that were my thoughts after I got some sleep :-)

Am I right in assuming that the quick guide on the POI web site is
generated from the xdocs content in the project repository? (i.o.W: adding
a topic is done by submitting a patch to the appropriate xml file?)

Best wishes,
Rainer Schwarze


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/




Doc changes, Was: Re: please help me out

2007-04-12 Thread Rainer Schwarze
At 05:20 12.04.2007, Rainer Klute wrote:
>If this question is asked every now and then it is worth to be answered
>before the question is raised. This saved you and the user some effort -
>not to mention those users that won't ask but simply think that HWPF
>isn't useful and look for an alternative. And I wouldn't call the
>question "What HWPF cannot do" but rather "How to create a new Word
>document".

Hi,

that were my thoughts after I got some sleep :-)

Am I right in assuming that the quick guide on the POI web site is
generated from the xdocs content in the project repository? (i.o.W: adding
a topic is done by submitting a patch to the appropriate xml file?)

Best wishes,
Rainer Schwarze


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/