JAVA 高级进阶之 POI 读取Excel(xls)类型文档的方法

发表于 | 更新于: | 分类于
字数统计: 43 | 阅读时长 ≈ 1

直接贴源码（jsp页面的）：

<%@ page language="java"   pageencoding="gb18030" import="java.io.*,org.apache.poi.poifs.filesystem.poifsfilesystem,org.apache.poi.hssf.record.*,org.apache.poi.hssf.model.*,org.apache.poi.hssf.usermodel.*,org.apache.poi.hssf.util.*" %>  
  
Read Excel file   
  
  
An example of using Jakarta POI's HSSF package to read an excel spreadsheet: 

  
  
Select an Excel file to read.   
    


<%  string filename =" request.getParameter("xls_filename"); "  if (filename !=" null && !filename.equals("")) {" %="">   
 
You chose the file <%= filename %>.   
 

It's contents are:    
<%              try=""             {=""                 =""  create a poi workbook from the excel spreadsheet file=""                 poifsfilesystem fs ="                    new POIFSFileSystem(new FileInputStream(filename));"                 hssfworkbook wb =" new HSSFWorkbook(fs);"                 for (int k =" 0; k < wb.getNumberOfSheets(); k++)"                 {="" %="">      
                    

Sheet  <%= k %> 
  
                      
<%           =""                     hssfsheet sheet =" wb.getSheetAt(k);"                     int       rows  =" sheet.getPhysicalNumberOfRows();"                     for (int r =" 0; r < rows; r++)"                     {=""                         hssfrow row   =" sheet.getRow(r);"                         if (row !=" null) { "                             int     cells =" row.getPhysicalNumberOfCells();" %="">  
         <%=""%>   
<%                             for (short c =" 0; c < cells; c++) "                             { =""                                 hssfcell cell  =" row.getCell(c);"                                 if (cell !=" null) { "                                     string   value =" null;"                                     switch (cell.getcelltype())=""                                     {=""                                         case hssfcell.cell_type_formula :=""                                             value ="" ; ="" "formula ";=""                                             break;=""                                         case hssfcell.cell_type_numeric :=""  ="" "numeric value="  
                                                    + cell.getNumericCellValue  
();  
                                            break;

                                        case HSSFCell.CELL_TYPE_STRING :  
                                            value =" " ="" "string value="  
                                                    + cell.getStringCellValue();  
                                            break;

                                        default :  
                                    }  
%>           
                                    <%= " "  + value +"" %>  
<%                                 } =""                             }%=""><%="< tr="">" %>  
                   <%     }                     }%=""><%="< table="">" %>  
             <%   }             }=""             catch (exception e)=""             {="" %="">  
 Error occurred:  <%= e.getmessage() %>  
<%                    e.printstacktrace();=""             }=""  } ="" %=""> 

0%