Import org. Apache. Poi. hssf. usermodel .*;
Call the hssfworkbook object after the poi is imported. For example: Try {
// Create an Excel Workbook file reference
Fileinputstream fin = New Fileinputstream (fname );
File fexcel = New File (fname );
Try {
Hssfworkbook workbook = Null ;
Try {
//System. Out. println ("Haha ");
Workbook= NewHssfworkbook (FIN );
//System. Out. println ("hihi ");
} Catch (Exception E)
{
E. printstacktrace ();
Hashmap HH = New Hashmap ();
HH. Put ( " Infor " , " The Excel file format is incorrect! " );
Falselog ( - 1 , - 2 , HH, " The Excel file format is incorrect! " );
Return ;
}
Workbook = new hssfworkbook (FIN); an error is reported here,
The reason is that "data"-> "filter"-> "automatic filter" must be disabled in Excel. Otherwise, the file stream reading will fail and an error in format is reported.
Don't do it. I really don't know... I 've been searching for a long time...