代码中显示HSSFWorkbook错误

请查看POI忙碌的开发人员指南,这方面有很多示例: http://poi.apache.org/spreadsheet/quick-guide.html

您需要InputStream、OPCPackage或NPOIFSFileSystem进行读取(这是NPOIFSFile System的示例):

// HSSFWorkbook, File
NPOIFSFileSytem fs = new NPOIFSFileSystem(new File("file.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fs.getRoot());
....
fs.close();

您需要使用inputstream提供excel文件的路径,

FileInputStream input= null;
input= new FileInputStream(new File(path));
HSSFWorkbook wb = new HSSFWorkbook(input);

输入应与FileInputStream类似

     String fileName="/home/hduser/file.xls";
     FileInputStream file = new FileInputStream( new File( fileName ) );
     String fileExtension = FilenameUtils.getExtension( fileName );
     Workbook channelBook = getChannelWorkBook( fileExtension, file );

    /**
 * Get Workbook from extension
 */
private Workbook getChannelWorkBook( String fileExtension, FileInputStream file ) throws IOException
{
    if ( fileExtension.equalsIgnoreCase( "XLS" ) )
        return new HSSFWorkbook( file );
    if ( fileExtension.equalsIgnoreCase( "XLSX" ) )
        return new XSSFWorkbook( file );
    return null;
}