RE: resultset from Oracle to a HSSFSheet

2006-01-25 Thread Marot Laurent
just increase your heap size with -Xmx Laurent Marot ___ ALLIACOM 98 Avenue du Général Leclerc 92 100 Boulogne Billancourt - France Phone +33 (0)1 55 38 98 98 Mobile 06 21 09 52 29 www.alliacom.com -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMA

RE: How to generate EXCEL in JSP

2004-12-06 Thread Marot Laurent
you'll work same way with jsp/srvlets -Message d'origine- De : Balaji [mailto:[EMAIL PROTECTED] Envoyé : lundi 6 décembre 2004 10:54 À : POI Users List Objet : Re: How to generate EXCEL in JSP Hi friends, I have developed Export to excel report from Java Swing appln with POI, now my req

RE: How can I insert a html link into a cell value?

2004-11-23 Thread Marot Laurent
have a look there: http://www.mail-archive.com/poi-user@jakarta.apache.org/msg03729.html Laurent -Message d'origine- De : Hunter Ren [mailto:[EMAIL PROTECTED] Envoyé : mardi 23 novembre 2004 21:01 À : POI Users List Objet : How can I insert a html link into a cell value? I want to ins

RE: examples regarding reading excel files

2004-08-16 Thread Marot Laurent
Hi, i think taht everything is there : http://jakarta.apache.org/poi/hssf/quick-guide.html#ReadWriteWorkbook you can also have a look there: http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi.html -Message d'origine- De : janarthanankesavan [mailto:[EMAIL PROTECTED] Envoyé : ven

RE: how To get org.apache.poi.hwpf.* package

2004-06-04 Thread Marot Laurent
are you sure i can only find : org.apache.poi.hdf... in poi-scratchpad-2.5-final-20040302.jar -Message d'origine- De : Dipankar [mailto:[EMAIL PROTECTED] Envoyé : vendredi 4 juin 2004 10:00 À : POI Users List Objet : Re: how To get org.apache.poi.hwpf.* package HWPF is in the scratchpad

RE: New To POI

2004-06-03 Thread Marot Laurent
Hi, just download the archives there : http://jakarta.apache.org/site/binindex.cgi and add the .jar(s) to your project properties Required librairies in JBuilder Laurent -Message d'origine- De : Srinivas Rao [mailto:[EMAIL PROTECTED] Envoyé : jeudi 3 juin 2004 09:06 À : [EMAIL PROTECTE

RE: Question about Cell Styles in Excell

2004-05-11 Thread Marot Laurent
Hi Guys, I think that template using is the easyest way to create an maintain High-level formated cells in sheets. Just one problem encountered : when i have two differents font style in a single sample, POI usage will erased the second style used; Has someone already noticed this problem ?

RE: header and footer

2004-05-04 Thread Marot Laurent
HSSFHeader header = s.getHeader(); header.setCenter("bla bla"); header.setLeft("ok "); header.setRight(HSSFHeader.font("Stencil-Normal", "Italic") + HSSFHeader.fontSize((short) 10) + "Test Workbook"); -Message d'origine- De : Alexandru, Ionita [mailto:[EMAIL PROTECTED] Envoyé : mardi 4 ma

RE: Is it possible ...?

2004-03-23 Thread Marot Laurent
use setProtect(boolean protect) Sets the protection on enabled or disabled and lock cells with setLocked(boolean locked) set the cell's using this style to be locked works fine with no encryption -Message d'origine- De : Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED]

RE: Add listbox to spreadsheet via POI

2004-02-27 Thread Marot Laurent
Hi Ryan, unfortunatly I have experienced this situation some weeks ago, and the only solution i found was to use template sheets with dropdown list already defined in it. Laurent -Message d'origine- De : Ryan Crumley [mailto:[EMAIL PROTECTED] Envoyé : vendredi 27 février 2004 21:47 À :

[SOLVED] Problen with writing big Excel file (2 172 kBytes)

2004-02-10 Thread Marot Laurent
Works fine increasing heap size with : set CATALINA_OPTS=-Xms64m -Xmx512m in catalina.bat -Message d'origine- De : Marot Laurent Envoyé : jeudi 5 février 2004 10:54 À : POI Users List Objet : Problen with writing big Excel file (2 172 kBytes) Hi all, I'm requesting a d

RE: Problem with writing big Excel file

2004-02-09 Thread Marot Laurent
589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) root cause java.lang.OutOfMemoryError -Message d'origine- De : Marot Laurent Envoyé : jeudi 5 février 2004 10:54 À : POI Users List

RE: HOw to read Oracle Data into Excel

2004-02-06 Thread Marot Laurent
just a short extract from a JSP page hope this will help OutputStream outp = new FileOutputStream("test.xls"); HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet s = wb.createSheet(); wb.setSheetName(0,"Sheet_name"); HSSFRow r = null; HSSFCell c = null; int rowCount = 0 resultset = statement

Problen with writing big Excel file (2 172 kBytes)

2004-02-05 Thread Marot Laurent
Hi all, I'm requesting a database to create a single sheet workbook in a JSP page. I'm using POI 2.0 Final on Linux Red Hat 4CPU 1 Mbyte Ram Everything works fine if my resultset (80 fields) contains less than 1979 reccords but when i jump to 1981 records i get the error below. is there a codi

Data Validation Drop Down

2004-02-02 Thread Marot Laurent
Hi there, i'm looking for some help creating Data Validation Drop Down with POI. i've read a few mails in the poi-user mail archive list but no new and definitive answer about it's feasibilily. Could someone please tell me if possible or not and send good advices. Thanks a lot. -

[Solved] RE: Problem with sheet reference

2004-01-28 Thread Marot Laurent
Objet : Re: Problem with sheet reference that looks right. pop in a bugzilla with the code you have here: http://nagoya.apache.org/bugzilla/buglist.cgi?product=POI Marot Laurent wrote: > Hi all, > > I'm facing a proble with code below: > > HSSFWorkbook wb = new

Problem with sheet reference

2004-01-27 Thread Marot Laurent
Hi all, I'm facing a proble with code below: HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet s = wb.createSheet(); wb.setSheetName(0,"Feuille1"); //wb.setSheetName(1,"Feuille2"); HSSFRow r = null; HSSFCell c = null; // Définitions HSSFName nomTest = wb.createName(); nomTest.setNameName("myname"

Problem with setCellFormula() method

2004-01-27 Thread Marot Laurent
Hi all, i've just downloaded POI 2.0-FINAL release and i'm facing a problem with setCellFormual() method. When i work with a single sheet workbook (my sheet is named Catalogue) i have no problem with using this kind of formula: c.setCellFormula("SUM(Catalogue!I4:I5)"); and even c.setCell

RE: question about single cell named ranges

2004-01-16 Thread Marot Laurent
À : [EMAIL PROTECTED] Objet : Re: question about single cell named ranges Marot Laurent wrote: >> Hi guys, >> >> i 'm facing the problem below when trying to set a name to a cell >> >> i get this exception trying the code

question about single cell named ranges

2004-01-16 Thread Marot Laurent
> Hi guys, > > i 'm facing the problem below when trying to set a name to a cell > > i get this exception trying the code below > java.lang.ArrayIndexOutOfBoundsException: 1 at > org.apache.poi.hssf.record.formula.Area3DPtg.setArea(Area3DPtg.java:285) at > org.apache.poi.hssf.record.NameRecor