We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Problem with named range


Can any one tell me how many Named range we can declare in workbook.

and is there any limit for length of named range characters.

I defined the range for Data validation to show as Drop down list.

I am getting following error when i am opening excel file.

"Excel found unreadable content in filename.xlsx"

Please any one can suggest any solution for this.

Thanks in advance


Well, Aspose.Cells follows MS Excel standards and works the same way as MS Excel. I think apparently there is no limit to create the number of named ranges, you may have as many as you want but it would depend on your available memory.

For your issue, could you create a sample console application (runnable) with v7.5.0.x, zip it and post it here, we will check your issue soon. Also attach your template Excel file(s).

Thank you.