Get the value of a named column

Question

HelloI'm working with your Essentials JS 1 SpreadsheetSince in Excel you can define cell names, is it possible to get the value of a cell by providing its name, instead of the coordinates?Thanks

Sangeetha Priya Murugan · Accepted Answer

Hi Massimiliano,Your reported requirement can be
achievable in our spreadsheet by getting nameManager collection from the
spreadsheet model as like as below.Code Block:

function btnClick(args) {
          var excelObj =
  $("#Spreadsheet").ejSpreadsheet("instance");
          console.log(excelObj.model.nameManager) // print the
  nameManager in console
  }

For your convenience we have prepared
the sample based on our suggestion in a button click event. Please find the
link below.Sample Link: https://jsplayground.syncfusion.com/52rjlrvrDocumentation Link: https://help.syncfusion.com/js/spreadsheet/formulas#named-rangesCould you please check the above links
and get back to us, if you need any further assistance on this.Regards,Sangeetha M