sql帅的博客

FormFile formFile = (FormFile) form.get("formFile");
List list = new ArrayList();
   
InputStream file = null;

try {
   file = formFile.getInputStream();
   Workbook wb = null;
   try {
    wb=Workbook.getWorkbook(file);  //中文乱码解决
   } catch (BiffException e) {
    e.printStackTrace();
   }
   if(wb==null)
    return null;
   Sheet[] sheet = wb.getSheets();
 
   if(sheet!=null&&sheet.length>0)
   {
    int rowNum = sheet[1].getRows();
    
    for(int i = 0 ; i < rowNum ;  i ++)
    {
     
     Cell[] c = sheet[1].getRow(i);
     
     if(c != null && c.length > 0)
     {
      
      if(c[1] != null && !"".equals(c[1].getContents().toString()))
      {

         。。。

      }

     }

    }

}

中文乱码解决：（把红色部分改为）

WorkbookSettings workbookSettings=new WorkbookSettings(); 
workbookSettings.setEncoding("GBK"); 
wb=Workbook.getWorkbook(file,workbookSettings);