Example: importFile method

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

importFile method