When import from Excel the custom names are on the workbook

When import from Excel the custom names are on the workbook

Posted by: kim.dok on 8 January 2023, 9:10 am EST

• 

  kim.dok

  • Post Options:
  • Link
    Copy

  Posted 8 January 2023, 9:10 am EST

  Hi, when we are trying to import an Excel file into SpreadJS, we are getting all of the custom names on the workbook , and the sheets’ custom names array is empty.
  
  Also we couldn’t find a way to understand to which sheet every one of the workbook custom names belong to.

  Can we have some guidance on how to achieve the required outcome?

  Thanks.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 9 January 2023, 12:21 am EST

  Hi,

  The Scope of the name is picked from excel so if you define a custom name in Excel with the workbook scope then it would be added to the spreadJS, at the workbook level. Further, if you need to get the sheet instance using the name you may use the following code snippet.

  
  spreadInstance.getCustomNames("workbooklevelCustomName").getExpression().source.getSheet();

  Regards,
  
  Avinash