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

Free Support Forum - aspose.com

getRangeByName() API returns null in case sheetname contains exclamation mark "!"


I am using Aspose.Cells v8.6.2.4
In context of the attached sample excel document, I try to fetch the named range using the below code but it returns null.

String rangeName="‘Sheet!1’!Platform_5e00dc356c5140a2ac8dac48a550bff9";
Range namedRange = workbook.getWorksheets().getRangeByName(rangeName);

Can you figure out the issue?


Hi Jaspreet,

Thank you for contacting Aspose support.

We are able to replicate the said problem while using the latest version of Aspose.Cells for Java therefore we have logged this incident in our bug tracking system as CELLSJAVA-41650 for further investigation. Please spare us little time for proper analysis, and to get back with updates in this regard.


Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSJAVA-41650 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

The issues you have found earlier (filed as CELLSJAVA-41650) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.