insert rows and columns to Excel

2003-01-14 Thread FaQiang Ye
Hi! I'm a newer to POI and recently our project change FomulaOne to POI... Now, I have a problem. I want to insert rows and columns to Excel. But in POI documents I didn't found the methods. I did like this, but the num of row can't do that. ///

RE: Unable to build poi 1.8

2003-01-14 Thread narsi_kota
Paul, Thanks for your response. Yes, you are correct, I was trying to build with my own version of Ant. Now I have tried building by using the Ant provided with POI src distribution and it works fine and was able to build. Thanks once again. (Embedded image moved to file: pic09668.pcx)

RE: Unable to build poi 1.8

2003-01-14 Thread Paul Krause
It looks like you are building with your own copy of ant. You need to upgrade to 1.9 (from CVS) to build with your own ant. 1.8 has its own copy of ant, and builds must be started with build.bat or build.sh. See http://nagoya.apache.org/bugzilla/show_bug.cgi?id=15402 -- To unsubscribe, e-ma

Unable to build poi 1.8

2003-01-14 Thread narsi_kota
Hi! All, I am not able to build poi 1.8. I am getting the following error while preparing the build. BUILD FAILED file:C:/poi1.8/tools/antipede/build.xtarget:203: C: \poi1.8\tools\cents\automagic.cent.cent not found. Please advise on what needs to done. Thanks Narsi Kota -- To unsubsc

Re: Is is possible to incrementally write an Excel document createdu sing POI/HSSF?

2003-01-14 Thread Andrew C. Oliver
However anyone who wants to help, can! Grab the performance-branch tag! cvs co -r performance-branch jakarta-poi -Andy Avik Sengupta wrote: If Only! But no, we cannot incrementally flush a document to disk, since the file format contains upstream pointers to downstream data! So we have to hold

Re: Multiline rows

2003-01-14 Thread Christian Peter
Hi, according to http://jakarta.apache.org/poi/hssf/quick-guide.html#NewLinesInCells one should set setWrapText(true) for using newlines. No one mentions writing multiple lines without setWrapText(true). I tried it without setWrapText(true) but it never worked. OpenOffice works but not Excel.

Re: Multiline rows

2003-01-14 Thread Avik Sengupta
I thought cellStyle.setWrapText( true ) was MEANT to wrap at word boundaries?? Maybe you should try setWrapText (false) and increase cell height, and then use new lines in text? just an idea? On Tue, 2003-01-14 at 14:26, Christian Peter wrote: > Hi, > > I'm new to POI and I read the docs and th

Multiline rows

2003-01-14 Thread Christian Peter
Hi, I'm new to POI and I read the docs and the mailing archive. But I didn't find a solution for my problem (I probably missed something really obvious). I need multiline cells in my Excel Sheet. Therefore I used the cellStyle.setWrapText( true ); method to make it multiline. I thought I coul