Cell address in flexsheet

Cell address in flexsheet

Posted by: DEBLINA.TALUKDAR on 17 June 2019, 5:28 am EST

• 

  DEBLINA.TALUKDAR

  • Post Options:
  • Link
    Copy

  Posted 17 June 2019, 5:28 am 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)

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 18 June 2019, 5:08 am 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