To Whom It May Concern,
I downloaded this latest release of POI and tried out the tutorial. I find
that somehow, I'm unable to use the XSSF package. I looked in the jar file but
it doesn't seems the XSSF code is not there. I realized that it is now
combined and used under the interface SS. But when i tried to write this code:
XSSFWorkbook xssfWB = new XSSFWorkbook();
It complain that this class can't be resolved.
I'm unable to import this package. It doesn't seem to appear in the
3.5-Beta5.jar.
Also, when I try the code below:
InputStream inp = new FileInputStream("workbook.xls");
//InputStream inp = new FileInputStream("workbook.xlsx");
Workbook wb = WorkbookFactory.create(inp); <------this class highlighted
can't be found in the package either.
Sheet sheet = wb.getSheetAt(0);
Row row = sheet.getRow(2);
Cell cell = row.getCell(3);
if (cell == null)
cell = row.createCell(3);
cell.setCellType(Cell.CELL_TYPE_STRING);
cell.setCellValue("a test");
// Write the output to a file
FileOutputStream fileOut = new FileOutputStream("workbook.xls");
wb.write(fileOut);
fileOut.close();
Please help, I really need this for my work project which is on a tight
deadline within a new weeks. I need it to be able to read .xlsx files.
I notice the source code package I downloaded has XSSF inside folder OOXML. I
have the 3.5-Beta5.jar in my build path. I am missing any other lib or jars?
Please let me know.
Any feed back is greatly appreciated.
Thanks in advance,
Anh
_________________________________________________________________
How fun is this? IMing with Windows Live Messenger just got better.
http://www.microsoft.com/windows/windowslive/products/messenger.aspx
