This example opens 2 spreadsheets, creates a spreadsheet based on a template, and displays the name of second spreadsheet opened in Lotus Symphony, at last saves and closes all the spreadsheets.
import com.ibm.symphony.javaapi.Application; import com.ibm.symphony.javaapi.spreadsheet.Spreadsheet; import com.ibm.symphony.javaapi.spreadsheet.Spreadsheets; public class SpreadsheetsExample { public void example() { try { Application application = Application.getInstance(); Spreadsheets spreadsheets = application.getSpreadsheets(); Spreadsheet spreadsheet = spreadsheets.openSpreadsheet( "D:\\test.ods", true); Spreadsheet spreadsheet2 = spreadsheets.addSpreadsheet( "D:\\test.ots", false, true); Spreadsheet spreadsheet3 = spreadsheets.openSpreadsheet( "D:\\test3.ods", true); System.out.println(spreadsheets.item(2).getName()); spreadsheets.saveSpreadsheets(); spreadsheets.closeSpreadsheets(false); } catch (Exception e) { e.printStackTrace(); } } }
Related information