Cell address in flexsheet

Posted by: DEBLINA.TALUKDAR on 16 June 2019, 8:28 pm EST

  • Posted 16 June 2019, 8:28 pm EST

    Hi,

    I am absolutely new to flexsheet. Can I get the cell address of any cell with the given row and column number?

    Note: Can we use the below method in flexsheet?

    (Static: xlsxAddress

    xlsxAddress(row: number, col: number, absolute?: boolean, absoluteCol?: boolean, isWholeRow?: boolean): string)

  • Posted 17 June 2019, 8:08 pm EST

    Hello,

    Yes, you can use the above method in FlexSheet. You just need to pass the row and column index of the cell whose address you want to get. Please refer to the code snippet below:

    var address = wijmo.xlsx.WorkBook.xlsxAddress(0, 0); // will return A1
    

    You may also refer to the sample below:

    https://stackblitz.com/edit/js-pgnfv5

    API Reference:

    xlsxAddress: https://www.grapecity.com/wijmo/api/classes/wijmo_xlsx.workbook.html#xlsxaddress

    Regards,

    Manish Gupta

Need extra support?

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

Learn More

Forum Channels