Use POI to import Excel exception cannot get a text value from a numeric cell address

When you manipulate Excel because the Excel data cell has a different type, the cannot get a text value from a numeric cell's exception error occurs.

Exception reason: The Excel data cell has different types, and when we try to read a string from a numeric type cell and write to the database, a cannot get a text value from a numeric cell exception error occurs.

This exception is common in code similar to the following: Row.getcell (i). Getstringcellvalue ();

WORKAROUND: First set the cell type, convert the other type to string type first

Hssfcell cell = Row.getcell (j);
if (Row.getcell (j)!=null) {
Row.getcell (j). Setcelltype (cell.cell_type_string);
}
String value = Cell.getstringcellvalue ();

Use POI to import Excel exception cannot get a text value from a numeric cell address