excel4node icon indicating copy to clipboard operation
excel4node copied to clipboard

Named cells

Open SferaDev opened this issue 6 years ago • 1 comments

Excel allows a given Cell to have a name and refer to that cell using the name.

For example: A1 has name "_MyCell", B1 has formula "=_MyCell" and both output the same text.

Would this be easily implemented?

SferaDev avatar Oct 11 '18 10:10 SferaDev

Checking the code I see there's support but no reference about it. I'm using:

workbook.definedNameCollection.addDefinedName({ refFormula: "'SheetName'!" + Excel.getExcelCellRef(rowId, 3), name: '_' + value.id });

But I guess it would make sense to have it from worksheet.

SferaDev avatar Oct 11 '18 15:10 SferaDev