Hi Geetha,
Thanks.
The problem is not with defining the named range, the problem is with adding the vlookup to the sheet. When the line of code runs that adds the vlookup to sheet_1 I get an exception. The named range does not exist.
Excel would handle the vlookup nicely, XLSIO doesn't handle the
writing of the formula.
Regards,
>Hi,
Thank you for your interest in Syncfusion products.
You can add a NamedRange to the workbook using XlsIO. The following code snippet illustrates this:
IName lname1 = workbook.Names.Add("rcl");
lname1.RefersToRange = sheet_3.Range["A2:C22"];
And the above code worked fine for me.
Could you please try running the sample in the below link and let me know if you have any difficulties?
http://websamples.syncfusion.com/samples/XlsIO.Windows/F76781/main.htmRegards,
Geetha