WorksheetCollection.get(name) - does not find a sheet in the collection

Aspose.Cells Product Family
1
Hi,

I am working with an old version of aspose-cells-7.3.0, recently my application software was updated to Java 8.
With this configuration, I experience the following problem:
WorksheetCollection.get(name) returns null even if sheet with the same name exists.
But when invoking WorksheetCollection.add() with the same name - I get exception: “The same worksheet name already exists”.

Can you please say if this is a known problem ? Was it solved in a later version of Aspose-Cells ?
My existing license is expired so I cannot test with newer versions.

Thanks !
Tamir.

2

Hi,


I have tested your scenario/ case a bit using our latest version/fix, it works fine. I have used simple template file (attached), it has “MySheet1” worksheet. I used the following sample code with v8.7.2.x (latest version/fix):
e.g
Sample code:

Workbook workbook = new Workbook(“Bk_SheetTest1.xlsx”);
Worksheet sheet = workbook.getWorksheets().get(“MySheet1”);

System.out.println(sheet.getName()); //MySheet1 - Ok

Please try our latest version/fix, if you still find any issue, kindly do provide us sample code (runnable) and template file to show the issue, we will check it soon.

Thank you.