Named Ranges


#1

Aspose.Excel lets you create a named range in Excel by doing something like this…

Range range = cells.CreateRange(0,0,4,4);
range.Name = MyRange;

However, in Excel it is possible to have the same name for a named range on different worksheets. So worksheet1 can have the name MyRange as could worksheet2,3,4, etc. However, to do this you need to include a reference with the name like this…


Range range = cells.CreateRange(0,0,4,4);
range.Name = “’” + xlWorkSheet.Name + “’!MyRange”;

This is possible in VBA and using the interop assemblies but doesn’t work in Aspose.Excel.


#2

Hi, thanks for your consideration.

Yes, currently Aspose.Excel doesn’t support named ranges as you described. I will add this feature in the next hotfix.


#3

Laurence,

Thats great. Thanks for the quick response. Do you have an approximate release date for that hot fix?


#4

Dear DigitalC,

Just about 10/10. OK?


#5

Thats great, thank you.


#6


Dear DigitalC,

Just a quick note: hot fix 1.6.1 will be out Monday, just 2 days later than expected.

Thanks for your patience.


#7

Dear DigitalC,

HotFix 1.6.1 is released.

You can use the following code:

range.Name = sheet.Name + “!MyRange”;