How to get list cell have formula in a sheet

Posted by: nguyenthanhtuu1995 on 20 November 2022, 4:52 pm EST

    • Post Options:
    • Link

    Posted 20 November 2022, 4:52 pm EST

    Hi team,

    I wanna get a list cell have formula in a sheet. Please give me some solution.

    Thank and Best regards

  • Posted 21 November 2022, 10:31 pm EST


    You could use the toJSON() method to obtain the sheet’s json and iterate through the json’s dataTable to determine whether a cell contains a formula. Please see the following code example:

            let activeSheet = spread.getActiveSheet();
            let activeSheetJSON = activeSheet.toJSON({ includeBindingSource: true });
            let formulasArr = []
            let dataTable =;
            for (const row in dataTable) {
                for (const col in dataTable[row]) {
                    let data = dataTable[row][col];
                    if (data.formula) {
                        formulasArr.push({ row: row, col: col, formula: data.formula });


    toJSON method:



  • Posted 22 November 2022, 1:43 pm EST

    Thank @ankit.kumar

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels