Name ranges are not importing from a file which has some name ranges set it

Name ranges are not importing from a file which has some name ranges set it

Posted by: prashanthkul on 8 September 2017, 9:54 am EST

• 

  prashanthkul

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 9:54 am EST

  We are trying to evaluate wijmo spreadjs for our application. We use the import a excel file feature provided by wijmo spreadsheet, On importing a sheet with named ranges the names ranges go missing. We notice this while we try to export the workbook to excel.

  Let me know if more details are required.

  Regards,
  
  Prashanth
  
  2015/04/Pagebreak1.xlsx

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:54 am EST

  Hello,

  Unfortunately, we are unable to replicate the issue at our end with the given excel file and using Spread JS 2015 v1 build 16.

  We opened that Excel file in SpreadJS designer and it loads all the NameRanges. Please haev a look at attached screenshot for the same.

  We request you to send across a sample application so that we can investigate the issue further.

  We are sorry further investigation of the issue is not possible with the provided information. We request you to send across additional information if you wish to continue the investigation.
  
  And also let us know which version of SpreadJS are you using?

  Thanks,
  
  Reeva
  
  

• 

  tadekunle

  • Post Options:
  • Link
    Copy

  Posted 14 May 2021, 1:47 pm EST

  Hello,

  I am currently experiencing a similar problem. I am trying to merge multiple workbooks from Excel which works. However, when I merge the workbooks from Excel that have named cells, the named cells go missing and are not imported. Attached are images of the issue I am experiencing and a test excel file that can be used to reproduce the error, all in a zip file.

  Thank you,
  
  Tolu

  attachments.zip

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 17 May 2021, 9:26 am EST

  Hi,

  For this you need to also merge the names json to the target workbookJSON, Please refer to the following code snippet and attached sample that demonstrates the same.

  
   let newSheetName = getUniqueName(key, "", sheetNamesSet);
        if (wbJSON.names.length > 0) {
          wbJSON.names.forEach((name) => {
            if (name.formula.startsWith(sheetJson.name)) {
              name.formula = name.formula.replaceAll(
                sheetJson.name,
                newSheetName
              );
            }
          });
  targetWbJSON.names = targetWbJSON.names.concat(wbJSON.names);
  
  
  

  sample: https://codesandbox.io/s/spread-js-starter-forked-260gw?file=/src/index.js:1708-1733

  Regards,
  
  Avinash