I'm using java Google sheet api v4 which works pretty well. On thing I cannot figure out is the separator character for multiline cell value
Let say I have A2 cell in "mySheet" sheet which contains a multline value such as: Value1 Value2 Value3
String range = "mySheet!A2";
ValueRange valueRange = sheetService.spreadsheets().values().get(spreadsheet.getSpreadsheetId(), range).execute();
List<List<Object>> rowsValues = valueRange.getValues();
for (List<Object> rowValues : rowsValues) {
String rowValue = (String) rowValues.get(0);
List<String> splittedValue = Arrays.asList(objectType.split(?????));
}
I hope my question is clear enough.
Thanks a lot for your help.