Hi Edi,
im myself a newbie with POI but i just looked at this page:
http://poi.apache.org/hssf/quick-guide.html#CreateCells;)
so i think u have to write something like this:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
int i=0;
while (get new row from mssql)
{
HSSFRow row = sheet.createRow((short)i);
i++;
for (int n=0; n<11; n++)
{
HSSFCell cell = row.createCell((short)n);
cell.setCellValue(value of mssql field n);
}
}
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
greetings,
felix
---------------------------------------------------------------------
To unsubscribe, e-mail:
user-unsubscribe@...
For additional commands, e-mail:
user-help@...
