[jopendocument] Modify Multiple Work Sheets

[lucywei]

Hi, I am looking for help How to Modify Multiple Work Sheets.
Here is my code:    (myTest1.ods is template file with Multiple Work
Sheets)

public static void main(String[] args) throws FileNotFoundException,
IOException {

                File file = new File("myTest1.ods");

                final Sheet sheet1 =
SpreadSheet.createFromFile(file).getSheet("Sheet1");
                final Sheet sheet2 =
SpreadSheet.createFromFile(file).getSheet("Sheet2");

                
sheet1.getSpreadSheet().getTableModel("A2").setValueAt("2009009JY/
YH");

                sheet2.getSpreadSheet().getTableModel("B2").setValueAt(2288);

                File outputFile = new File("myTest1out.ods");

                 sheet1.getSpreadSheet().saveAs(outputFile);
                 sheet2.getSpreadSheet().saveAs(outputFile);
        }

The problem is that it only sheet2 data had been saved but it cannot
save sheet1 data.

Please help. Thanks in advanced.

Best regards,
Lucy
10 Feb. 2010