Hi
In a excel,
Firstly, I typed '1' in A1, then I changed the format of this cell to String.
Secondly, I changed the format of A2 to Standard(the default format), then I
typed '1' in this cell.
Finally, I saved this excel.
This is my excel file for test.
Iâm using poi 3.14.
My source is very simple, as following:
================================================
File file = new File("1.xlsx");
Workbook wb = WorkbookFactory.create(file);
Sheet sheet = wb.getSheetAt(0);
System.out.println(sheet.getRow(0).getCell(0).getCellType());
System.out.println(sheet.getRow(1).getCell(0).getCellType());
wb.close();
================================================
output:
============
0
1
============
The result shows that A1's type is CELL_TYPE_NUMERIC, and A2's type is
CELL_TYPE_STRING.
Though I set both cells to String, the results are different.
In addition, in this excel, the appearance of these two cells are also
different.
There is a green triangle at the top-right corner of A2.
Could anyone explain this for me?
Regards,
Young
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
