Hi Yong.

Does it also happen with a file built from the scratch?

We had big Excel files which we copied and modified and had problems
hard to understand. Building the file from the scratch we didn't have
any problems any more.

Regards,        Karl-Heinz.


-----Urspr�ngliche Nachricht-----
Von: Kong, Yong [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 24. September 2004 19:45
An: '[EMAIL PROTECTED]'
Betreff: Problem with VBScript

Hi,

I'm new to POI and I'm running into a problem that I need some help
with. 
I'd like to read in an Excel template with VBScripts built in,
insert/modify
some data and write out a new Excel file with the VBScripts intact. I
run
the following sample program but the VBScript in Excel was corrupted.
Any
ideas what caused the corruption and how to fix it? Thanks.

public class ReadWriteWorkbook
{
    public static void main(String[] args)
        throws IOException
    {
        POIFSFileSystem fs      =
                new POIFSFileSystem(new
FileInputStream("c:/workbook.xls"));
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        HSSFSheet sheet = wb.getSheetAt(0);
        HSSFRow row = sheet.getRow(4);
        if (row == null)
            row = sheet.createRow(4);
        HSSFCell cell = row.getCell((short)3);
        if (cell == null)
            cell = row.createCell((short)3);
        cell.setCellType(HSSFCell.CELL_TYPE_STRING);
        cell.setCellValue("test name");

        // Write the output to a file
        FileOutputStream fileOut = new
FileOutputStream("c:/workbook.xls");
        wb.write(fileOut);
        fileOut.close();

    }
}


The contents of this e-mail are intended for the named addressee only.
It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or
disclose
it to anyone else. If you received it in error please notify us
immediately
and then destroy it. 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to