Re: Example for Using POI to import Excel and Word?

[Stefan Neudorfer]

Hello Glen,

it's great - thank you.

I could not found a example so that I have some problems to go the first steps.

Regards,


       Stefan


Glen Stampoultzis wrote:

Word support is not done yet.

Here's an Excel example that reads a workbook, modifies it and writes it
back:

        POIFSFileSystem fs      =
                new POIFSFileSystem(new FileInputStream("workbook.xls"));
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        HSSFSheet sheet = wb.getSheetAt(0);
        HSSFRow row = sheet.getRow(2);
        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("workbook.xls");
        wb.write(fileOut);
        fileOut.close();

More documentation is available on the web site.

Regards,

Glen Stampoultzis  (TriNexus Pty Ltd)
+63 3 9753-6850     0402 835 458
ICQ:  62722370    EMail:  [EMAIL PROTECTED]



----- Original Message -----
From: "Stefan Neudorfer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 2:53 PM
Subject: Example for Using POI to import Excel and Word?

Hi,

we have to import and parse Excel and Word-files and we are looking for
a way to use POI.
Does someone have a simple example so that we can look for a way to use
POI in our applications (Swing, Batch)?


Thanks,



      Stefan Neudorfer