How can we access named ranges by using XlsIO?
You can access the named range through the workbook. It can be accessed through its name or its index, and you can add text to it or access the address of the referred range without having to access the worksheet. Please refer to the code snippet below.
C#
workbook.Names["A1"].RefersToRange.Text = "XlsIO";
VB
workbook.Names("A1").RefersToRange.Text = "XlsIO"