Cell.getStringValue() crash

Aspose.Cells Product Family
1

Hi,


I’ve been using Your API to get some data from excel file named “1010057(2).xlsx”, cell “K1”.
What I needed is string value of data, but execution fails when I called Cell.getStringValue(). I’ve got java.lang.IllegalArgumentException: Malformed pattern "'プロジェクトNo. ‘#######0’-'00"
Excel file is attached to the post.
Code that I used is below:

String _filePath = “/home/1010057(2).xlsx”;
String _cellName = “K1”;
Workbook book = new Workbook(_filePath);
WorksheetCollection wsc = book.getWorksheets();
Worksheet sheet = wsc.get(0);
Cells cells = sheet.getCells();
Cell cell = cells.get(_cellName);
if(cell.getType() == CellValueType.IS_NUMERIC)
System.out.println(cell.getStringValue());

Hopefully You’ll answer soon, thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please download and use the latest version: Aspose.Cells
for Java v7.4.3.1 it works fine. We have tested your issue with the latest version, it works without any issue.