-
New Feature
-
Resolution: Invalid
-
Major
-
None
-
None
-
Security Level: Jimmy
-
None
Currently need to update each cell via setValue API one by one, and this API will render lots of other command including text-align, color or font-size except just update their value (see screenshot.png attached).
There should an API like
Ranges.range(sheet, top_row, left_col, bottom_row, right_col).setValues(List<List<Object>>);
or
Ranges.range(sheet, top_row, left_col, bottom_row, right_col).setValues(Object[][]);
Furthermore, the generated response should be much simpler,
e.g.,
{top: 0, left: 0, wd: 30, hgh: 50, values:[[...], [...]]} // update 30 cols x 50 rows with values, starts from 0, 0.