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.