Excel Import Hssfworkbook and Xssfworkbook

Excel Import

The Excel version has the difference between version 03 and version 07, with a file suffix of. xls and. xlsx. They correspond to the POI in the workbook is also different, respectively, is Hssfworkbook and Xssfworkbook;

For different versions of Excel documents to use different tool classes, if used incorrectly, you will be prompted with the following error message.

Org.apache.poi.openxml4j.exceptions.InvalidOperationExceptionorg.apache.poi.poifs.filesystem.OfficeXmlFileException

You can use the method to determine the name of the file suffix, determine which object to generate, or you can use the following code:

Throws    ioexception,invalidformatexception {    if (!in.marksupported ()) {        new Pushbackinputstream (in, 8);    }    New IllegalArgumentException ("Your Excel version current POI cannot parse");}   

Excel Import Hssfworkbook and Xssfworkbook