Nodejs support

[Ily1606]

How to parse spreadsheet and get data on nodejs

Example: Input

{
"data": [
        {
            "id": 33,
            "record_date": "2023-09-01",
            "value": 0,
            "value_set": 0.2,
            "month_ago": 1,
            "final_rate": "=SUM(C1,D1)",
            "extendProps": {
                "id": 33,
                "record_date": "2023-09-01"
            }
        }
    ],
"columns": [
        {
            "name": "month_ago",
            "type": "text",
            "width": "100px"
        },
        {
            "name": "record_date",
            "width": "100px",
            "type": "text"
        },
        {
            "name": "value",
            "type": "number",
            "locale": "ja-JP",
            "mask": "0.00%;[Red]-(0.00%)",
            "width": "100px"
        },
        {
            "name": "value_set",
            "type": "number",
            "locale": "ja-JP",
            "mask": "0.00%;[Red]-(0.00%)",
            "width": "100px",
            "inputmode": "decimal"
        },
        {
            "name": "final_rate",
            "type": "number",
            "locale": "ja-JP",
            "mask": "0.00%;[Red]-(0.00%)",
            "width": "100px",
            "inputmode": "decimal",
            "readOnly": true
        },
        {
            "title": " ",
            "name": "id",
            "readOnly": true,
            "visible": false,
            "type": "text",
            "width": "100px"
        },
        {
            "name": "extendProps",
            "readOnly": true,
            "visible": false,
            "type": "text",
            "width": "100px"
        }
    ],
}

Output

{
"data": [
        {
            "id": 33,
            "record_date": "2023-09-01",
            "value": 0,
            "value_set": 0.2,
            "month_ago": 1,
            "final_rate": "=20",
            "extendProps": {
                "id": 33,
                "record_date": "2023-09-01"
            }
        }
    ],
}