Insert data into new Google sheet

Question

I want to create empty sheet and insert some data. I tested this code:

Sheets service = getSheetsService();

        // Fist create empty new sheet
        List<Request> requests = new ArrayList<>();

        requests.add(new Request().setAddSheet(new AddSheetRequest()
            .setProperties(new SheetProperties()
                .setTitle("scstc"))));

        BatchUpdateSpreadsheetRequest body = new BatchUpdateSpreadsheetRequest().setRequests(requests);
        BatchUpdateSpreadsheetResponse response = service.spreadsheets().batchUpdate(spreadsheetId, body).execute();

        // Second add data into new sheet
        List<List<Object>> writeData = new ArrayList<>();

        List<Object> dataRow = new ArrayList<>();
        dataRow.add("data 1 " + timestamp);
        dataRow.add("data 2 " + timestamp);
        dataRow.add("data 3 " + timestamp);
        dataRow.add("data 4 " + timestamp);
        dataRow.add("data 5 " + timestamp);
        writeData.add(dataRow);

        ValueRange oRange = new ValueRange();
        oRange.setRange(range); //
        oRange.setValues(writeData);

        List<ValueRange> oList = new ArrayList<>();
        oList.add(oRange);

        BatchUpdateValuesRequest oRequest = new BatchUpdateValuesRequest();
        oRequest.setValueInputOption("RAW");
        oRequest.setData(oList);

        BatchUpdateValuesResponse oResp1 = service.spreadsheets().values().batchUpdate(spreadsheetId, oRequest).execute();

The code is working but I have the following limitations:

The fist batch call creates empty sheet. The second batch call inserts the test data into wrong sheet, always the fist one.

How I can create new sheet and insert data with one call? If this is not possible how I can insert data into the new sheet?

Answer 1

The line oRange.setRange(range); // is missing the comment explaining what the line is intended to do. You don't have any line that assigns range to a value, so I'm not sure what you meant it to be.

If you want to write values into your new sheet, you need to make sure that range is pointing to that sheet, using range = "scstc" (which is the title of the sheet you added).

Alternately, you can do everything in a single BatchUpdateSpreadsheet request by specifying the sheetId in the SheetProperties object, and then also adding an UpdateCellsRequest pointing to the same sheetId, with the rowDatafilled out as you'd like it.