My question is perhaps very open, to explain my problem, I have a survey project, with all the logic already created, and I already insert data in MySql, my boss asks me to insert the data in google, to which I went to the quick start that offers Google Sheet Api , I created a function, which inserts data in Google Sheet, that's not my problem, the problem is that when I want to insert data they are inserted only in a column.
WHAT I WANT TO ACHIEVE IS THAT: - the data are inserted in an orderly manner downwards, always one row below. attached to you the code of the function, works perfectly, just that you have that problem, in advance thank you very much, I hope your friends answers!
private List<String> WriteExample() throws IOException {
// if(radio1.isChecked() || radio2.isChecked() || radio3.isChecked() || radio4.isChecked() || radio5.isChecked() ||
//radio6.isChecked() || radio7.isChecked()) {
datos.getOpciones().add(seleccionado);
datos.getOpciones2().add(seleccionado);
datos.getOpciones3().add(seleccionado);
datos.getOpciones4().add(seleccionado);
String spreadsheetId = "1jj-VI3r7giSz07GCAtNiNeFRxYhI_VNIcYtO3FsZDkE";
Sheets service = mService;
List<Request> requests = new ArrayList<>();
List<Request> requests2 = new ArrayList<>();
List<CellData> values = new ArrayList<>();
values.add(new CellData()
.setUserEnteredValue(new ExtendedValue()
.setStringValue(datos.getOpciones().toString()))
);
values.add(new CellData()
.setUserEnteredValue(new ExtendedValue()
.setStringValue(datos.getOpciones2().toString()))
);
values.add(new CellData()
.setUserEnteredValue(new ExtendedValue()
.setStringValue(datos.getOpciones3().toString()))
);
values.add(new CellData()
.setUserEnteredValue(new ExtendedValue()
.setStringValue(datos.getOpciones4().toString()))
);
requests.add(new Request()
.setUpdateCells(new UpdateCellsRequest()
.setStart(new GridCoordinate()
.setSheetId(0)
.setRowIndex(1)
.setColumnIndex(0)
)
.setRows(Arrays.asList(
new RowData().setValues(values)))
.setFields("userEnteredValue,userEnteredFormat.backgroundColor")));
BatchUpdateSpreadsheetRequest batchUpdateRequest = new BatchUpdateSpreadsheetRequest()
.setRequests(requests);
service.spreadsheets().batchUpdate(spreadsheetId, batchUpdateRequest)
.execute();
//}
//else{
// Toast.makeText(MainActivity.this, "Porfavor, seleccione una respuesta",Toast.LENGTH_SHORT).show();
//}
datos.getOpciones().clear();
datos.getOpciones2().clear();
datos.getOpciones3().clear();
datos.getOpciones4().clear();
return null;
}