Use poi to import the Excel file and solve cannot get a text value from a numeric formula Cell

Recent Excel Import

There are two methods: jxl and poi

Problems: jxl import: If a macro exists in the file, an error is reported. The solution cannot be found.

Poi import: memory overflow is caused by a large file size.

Exception in thread "Main" Java. Lang. illegalstateexception: cannot get a text value from a numeric formula Cell

This problem is because the cell uses the "sum function" and the content is not text.

Package cmcc.gz. platform. EMSs. purchase; import Java. io. fileinputstream; import Java. io. ioexception; import Java. io. inputstream; import Org. apache. poi. hssf. usermodel. hssfcell; import Org. apache. poi. hssf. usermodel. hssfrow; import Org. apache. poi. hssf. usermodel. hssfsheet; import Org. apache. poi. hssf. usermodel. hssfworkbook; public class xlsmain {public static void main (string [] ARGs) throws ioexception {Xlsmain = new xlsmain (); xlsmain. readxls ();} private void readxls () throws ioexception {inputstream is = new fileinputstream ("f :\\ import template v1.1.xls"); hssfworkbook = new hssfworkbook (is ); // cyclic worksheet sheet for (INT numsheet = 2; numsheet