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]
