Poi reads cells that process numbers in Excel

When I read EXCEL from poi, I encountered the following common case:

When you enter 1000 in a cell, poi needs to use getnumericcellvalue () to obtain the value, even though you set the cell to text in Excel.

If you insist on using getstringcellvalue (), the following error is returned:

Cannot get a text value from a numeric cell...

When you use getnumericcellvalue () to obtain the value, you will find that the value you get is 1000.0. Because poi treats it as a double.

In this case, we should do the following:

                HSSFCell cell7 = row.getCell(7);                cell7.setCellType(Cell.CELL_TYPE_STRING);                String content = cell7.getStringCellValue();                myModel.setContent(content);

That is, set the cell type to string in Java code.