Re: [jopendocument] Modify Multiple Work Sheets

[Sylvain Cuaz]

lucywei a écrit :

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)

        Hi, you need to load and save the file only once :

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");

final SpreadSheet spreadSheet = SpreadSheet.createFromFile(file);
final Sheet sheet1 = spreadSheet.getSheet("Sheet1");
final Sheet sheet2 = spreadSheet.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);

 }

final File outputFile = spreadSheet.saveAs(new File("myTest1out"));


Cheers,
Sylvain