This example imports all the data from a CSV file.
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.importCSVFile("C:\\Scenario\\CsvFile.csv", "-", "", 1, Constant.SYMPHONY_SHEET_IMPORTMODE_NORMAL); } catch(Exception e) { e.printStackTrace(); }
Related information