i 'm trying compile a little example using poi i want generate a simple doc file the problems comes while importing the hwpf package i can 't find it shoud i download the source from cvs
I want to export the contents of html page(JSP) to Excel.The jsp page
will be displayed on the browser and on the click of a button I need to
export the data into excel.On my page I have chHi
I 'm trying to use POI to format some date values in a spreadsheet. I
need to get the date format in just month/day format (without the
year). I 've been trying to do that with the followinI tried to use the setting of page numbers according
to the example under Developer 's guide.
HSSFWorkbook wb new HSSFWorkbook()
HSSFSheet sheet wb.createSheet( "xxx ")
HSSFFooter footer shI can 't really include more of a code segement than I already did... \. But the problem I 'm having doesn 't seem to come from the rows themselves which works fine for me as well but the problem is inHello!
For my application I need the ability to create charts in a POI
generated Excel document.
I am thinking about implementing this feature.
I would like to receive hints on following queHello i am using
redhat linux enterprise
When generating a 1000+ row x 54 col excel sheet using HSSF the java servlet
throws an outofmemory exception everytime (if Has MutableSection been removed from the POI 2.0 distribution? I can 't find
the class yet it is mentioned in the POI website how-to.
I 'm trying to set a print area so that my file can fit on one page. However I 'm not getting the results I need from the setPrintArea() - both methods.
This is what I 'm doing
I am new to POI and I am using HSSF for now. I create
xls files but there is a problem with character
encodings when I send Turkish characters from my java
class to xls file I can not see the > I wrote some pagebreak additions to RC2 but have been holding off on
> committing till after the release. I 'll post a patch for the people
> that need it once I redo it (I did a partial diff anHi
in Excel you can define different levels for rows to collapse or expand the
rows. Is there a possibility to do the same thing with POI?
____ Hi everyone
in Excel you can set pagebreaks manually and save them with the file. Is
there a possibility to do the same thing with POI?
Alternative it would do if I can determin somehow wether Just so you know.
I created an ant task called xls2xml. It is available from
Its intention is to be able read excel sheets and convert the data it
contains inHi Lars.
I am just able to walkthrough the OLE 2 FileSystem using POIFS.
I can reach the WordDocument file inside doc file but I am not able to
extract properly !
Anyway Ryan Ackely gave me a woPaolo
I also need to extract text from a Word document modify it and then write
it back. I 'm also completly new to OLE and ist specifications. Could you
help me out with your workthru code I wHi Brian.
We use also this development version and wait for the release version
which shall come soon (or maybe was already released in the meantime)
and didn 't discover problems.
We use a lothttp //textmining.org
----- Original Message -----
From "Paolo Tortora " <p.tortora@(protected) >
To "POI Users List " <poi-user@(protected) >
Sent Wednesday December 17 2003 1
Hmm... I tried this but it did not seem to work.
Here 's my code
import org.apache.poi.poHi Sky.
I am a beginner with POI/Word.
I am able to walkthrough a OLE 2 Compound Document with POIFS and I know
how to identify the WordDocument within.
Please Do you have (or somebody else)
> We don 't have control over the exception. Its coming from
I know no offence meant. Sun should work a little bit on its messages.
My most hated exception is NoS
My project requires some tables to be written onto Word from JAVA. Anyone has already done
it? I got a piece of code
which enables to write into the word some plain text. But i need only ta
I 'm having a similar problem. I read Excel 97 spreadsheets that were
written and saved in Excel itself but I do not get the formula values -
they are always 0.0.
I 'm a little conOk I found the solution for this error.
Accidentaly I tried to write the stream out twice. Between the first and
the second try of writing I closed the OutputStream. So poi was trying
to write to Hi All
I could finally resolve this formula problem. Just to give you all what had
happened and how it got resolved.
The sheet reference formula requires that the sheet name should not containI am getting following exception when writing a workbook to file
java.io.IOException Bad file descriptor
at java.io.FileOutputStream.writeBytes(Native Method)
Which version of excel is supported by POI?
I write to an excel(which has formulas) file using POI2.0. But looks
like the writing to excel is fine. When i try to get the value it does
I have a sheet with formula for cell C3. formula is sum(c1 c2)
I insert values to c1 and c2. If I try to get the value of C3 I get 0.0
How do I get the value of c3 cell? Even if i save all the datI am working on a project that require me to copy single or multiple rows or single cell or
multiple cells within a workbook. IS there any way that I can do that?
Does anyone having POI-scratchpad example program to read MSWord document.
Im trying with poi-scratchpad-2.0-RC1-20031102.jar parser but getting
Error - java.io.IOException U|