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:[EMAIL PROTECTED] >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:[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] > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > From rajashekhar
