poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajashekhar gandla" <raja_gan...@rediffmail.com>
Subject Re: AW: HOw to read Oracle Data into Excel
Date Mon, 09 Feb 2004 07:55:47 GMT
Hi,
 i am very much thank u for giving response. i will check now. 
thank u for sending code. bye..bye...
i am very much thankful to u.

From
raja

On Fri, 06 Feb 2004 Karl-Heinz Zengerle wrote :
>Hi raja.
>
>Don't forget to use the external jar cocdbinterface.jar. Otherwise the
>code will be compileable but it will not run.
>
>Regards,	Karl-Heinz Zengerle.
>
>
>-----Ursprüngliche Nachricht-----
>Von: Marot Laurent [mailto:Laurent.Marot@alliacom.com]
>Gesendet: Freitag, 6. Februar 2004 10:28
>An: POI Users List; rajashekhar gandla
>Betreff: RE: HOw to read Oracle Data into Excel
>
>
>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.executeQuery("SELECT * FROM TABLE");
>while (resultset.next()) {
>  r = s.createRow(rowCount);
>  c = r.createCell((short)0);
>  c.setCellValue(resultset.getString("Field 1"));
>  .
>  .
>  .
>  c = r.createCell((short)i);
>  c.setCellValue(resultset.getString("Field i"));
>
>  .
>  i++;
>}
>
>
>
>
>
>-----Message d'origine-----
>De : rajashekhar gandla [mailto:raja_gandla@rediffmail.com]
>Envoyé : vendredi 6 février 2004 06:48
>À : poi-user@jakarta.apache.org
>Objet : HOw to read Oracle Data into Excel
>
>
>HI all,
>my problem is. i stored some data in the database(with 3 colums like
>no., name, address). now i want to display all that data in to excel
>sheet with diffrent colums.
>if anybody help i am very much thanks to that person.
>thanks u.
> From
>raja shekhar
>
> From
>rajashekhar
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>


From
rajashekhar
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message