poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vu, Anh" <v...@hotmail.com>
Subject POI 3.5Beta5 issue
Date Sun, 22 Feb 2009 01:40:11 GMT

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.setCellValue("a test");

    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook.xls");


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,


How fun is this? IMing with Windows Live Messenger just got better.
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message