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 Marot Laurent wrote :
>
>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:[EMAIL PROTECTED]
>Envoy� : vendredi 6 f�vrier 2004 06:48
>� : [EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
From
rajashekhar
