This example imports the data of sheet A from line 3.
try { Application application = Application.getInstance(); Spreadsheets spreadsheets = application.getSpreadsheets(); Spreadsheet spreadsheet = spreadsheets.openSpreadsheet("D:\\test.ods", true); Sheets sheets = spreadsheet.getSheets(); Sheet sheet = sheets.item(1); sheet.importFile("C:\\Scenario\\sheet.ods", "A", 3, Constant.SYMPHONY_SHEET_IMPORTMODE_NORMAL); } catch(Exception e) { e.printStackTrace(); }
Related information