Code is very simple:
-----------------------------------------------
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(
"c:\\test1.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = sheet.getRow(0);
HSSFCell cell = row.getCell((short) 3);
if (cell == null)
cell = row.createCell((short) 3);
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
cell.setCellValue("a test");
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("c:\\out.xls");
wb.write(fileOut);
fileOut.close();
-----------------------------------------------
Sheet1 of test1.xls includes a image, the exported file(out.xls) cann't be
recognized by Excel 2003 SP3: if you open the out.xls file with Excel 2003 SP3
you get an error message that Excel found unreadable content in that file.
POI version is 3.2 final.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
