Not supported row range address in definedNames

[reprisdinjus]

ExcelJs supports definednames when the address points to a range of cells but does not support definednames when the address points to a range of rows.

Example of row range address: "$1:$1".

If you did not expect ExcelJs to support row ranges, you should be aware that there is a loss of address information when loading the xlsx file. This prevents the row range address from being retrieved after loading into 'workbook.definedNames'.

This is due to the following code:

// xlsx.js file
class XLSX {
     [...]
     async load(data, options) {

        [...]

        // apply model
        this.workbook.model = model;  // ◄
        return this.workbook;
    }

    [...]

}

And:

  set model(value) {

      [...]

    this._definedNames.model = value.definedNames; // ◄
    this.views = value.views;
    this._themes = value.themes;
    this.media = value.media || [];
  }

And finally:

 set model(value) {
    // value is [{name, ranges}, ...]
    const matrixMap = (this.matrixMap = {});
    value.forEach(definedName => {
      const matrix = (matrixMap[definedName.name] = new CellMatrix());
      definedName.ranges.forEach(rangeStr => {
        if (rangeRegexp.test(rangeStr.split ('!'). pop () || '')) {
          matrix.addCell(rangeStr);
        }
      });
    });
  }

The 'addCell' function does not understand the supplied line range address.

I suggest you modify the code to keep the address in the CellMatrix like this:

 set model(value) {
    // value is [{name, ranges}, ...]
    const matrixMap =(this.matrixMap = {});
    value.forEach(definedName => {
      const matrix = (matrixMap[definedName.name] = new CellMatrix());
      matrix.ranges = [];  // ◄ line code to insert
      definedName.ranges.forEach(rangeStr => {
        matrix.ranges.push(rangeStr);  // ◄ line code to insert
        if (rangeRegexp.test(rangeStr.split ('!'). pop () || '')) {
          matrix.addCell(rangeStr);
        }
      });
    });
  }

This will allow developers to find this information even if ExcelJs does not support row ranges.

Hoping to help you improve ExcelJs.