Example: Spreadsheets

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

Spreadsheets