Put Cells

PUT /api/putCells

Update the changed cells to the server. Can be either value update or formula update.

Parameters

JSON Body Parameters

Field	Data Type	Description
bookId	String	The id of the current book.
sheetName	String	The name of the deleted sheet.
range	String	The current fetching range of the sheet.
cells	collection of cells	The collection of cells to put into the sheet.

Example

Request

PUT https://localhost:8080/api/putCells
JSON Parameters:
{
    "bookId": "cjfx4leqo",
    "sheetName": "Grade",
    "range" : {"row1": 0, "col1": 0, "row2": 100, "col2": 10},
    "cells": [
        {
            "row": "2",
            "col": "1",
            "value": "3.3",
            "formula": "",
            "type": "float",
            "format": ""
        },
        {
            "row": "2",
            "col": "2",
            "value": "A-",
            "formula": "",
            "type": "string",
            "format": ""
        }
    ]
}

Response

{
    "status": "success",
    "message": null,
    "data": null
}