sheets_write
Write a block of values and formulas into a spreadsheet sheet, starting at start_cell (default A1). rows = [[…], …]; null leaves a cell as it is, "" clears it; same value rules as sheets_create. Everything else in the workbook (other cells, styles, widths, merges, other sheets) is kept. Optional number_format (e.g. '0.00', '$#,##0.00', '0%', 'yyyy-mm-dd') applies to the written cells. Saves a NEW version (restorable from Versions in the editor). Pass expected_version (from sheets_read) so the write is refused if someone changed the file since you read it.
Parameters
- file_id (string, required)
- sheet (string, required)
- rows (array, required)
- start_cell (string, default "A1")
- number_format (string)
- expected_version (integer)