Get Cells

GET /api/getCells/{bookId}/{sheetName}/{row1}/{col1}/{row2}/{col2}

Return a collection of cells and tables within the current range of the sheet.

Parameters

Path Parameters

bookId, sheetName, row1, col1, row2, col2

Example

Request

GET https://localhost:8080/api/getCells/cjfx4leqo/GPA/0/0/10/10

Response

{
    "status": "success",
    "message": null,
    "data": {
        "cells": [
            {
                "row": "1",
                "col": "1",
                "value": "3.7",
                "formula": "",
                "type": "float",
                "format": ""
            },
            {
                "row": "1",
                "col": "2",
                "value": "A",
                "formula": "",
                "type": "string",
                "format": ""
            }
        ],
        "tables":[
            {
                "cells": [
                    [
                        3.7, 3.9
                    ],
                    [
                        "A", "A+"
                    ]
                ],
                "attributes": [
                    {
                        "name": "GPA",
                        "type": "float",
                        "order": null
                    },
                    {
                        "name": "Grade",
                        "type": "text",
                        "order": "ASC"
                    }
                ],
                "range": {
                    "row1": "1",
                    "row2": "2",
                    "col1": "1",
                    "col2": "2"
                },
                "filter": "GPA>3",
                "linkTableId": "1jds9u13ie",
                "link": "1wde8u132ijwe0ufi132ne90"
            }
        ]
    }
}