POI读取Excel

package servlet;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
/**author:wx
* describe:Reads the Excel example
* */
public class ReadExcel extends HttpServlet {
    /**
     *
     */
    private static final long serialVersionUID = 1L;
    /**
     * Constructor of the object.
     */
    public ReadExcel() {
        super();
    }
    /**
     * Destruction of the servlet. <br>
     */
    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }
    /**
     * The doGet method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to get.
     *
     * @param request
     *            the request send by the client to the server
     * @param response
     *            the response send by the server to the client
     * @throws ServletException
     *             if an error occurred
     * @throws IOException
     *             if an error occurred
     */
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }
    /**
     * The doPost method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to
     * post.
     *
     * @param request
     *            the request send by the client to the server
     * @param response
     *            the response send by the server to the client
     * @throws ServletException
     *             if an error occurred
     * @throws IOException
     *             if an error occurred
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=gb2312");
        PrintWriter out = response.getWriter();
        String filePath = new String(request.getParameter("file").getBytes(
                "ISO-8859-1"), "gb2312");
       
        out.print("文件路径："+filePath+"<br>");
        try {
            POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(
                    filePath));
            // 创建工作簿
            HSSFWorkbook workBook = new HSSFWorkbook(fs);
            /**
             * 获得Excel中工作表个数
             */
            out.println("工作表个数 :"+workBook.getNumberOfSheets()+"<br>");
            for (int i = 0; i < workBook.getNumberOfSheets(); i++) {
               
                out.println("<font color='red'> "+i+" ***************工作表名称："+workBook.getSheetName(i)+"  ************</font><br>");
                // 创建工作表
                HSSFSheet sheet = workBook.getSheetAt(i);
                int rows = sheet.getPhysicalNumberOfRows(); // 获得行数
                if (rows > 0) {
                    sheet.getMargin(HSSFSheet.TopMargin);
                    for (int j = 0; j < rows; j++) { // 行循环
                        HSSFRow row = sheet.getRow(j);
                        if (row != null) {
                            int cells = row.getLastCellNum();//获得列数
                            for (short k = 0; k < cells; k++) { // 列循环
                                HSSFCell cell = row.getCell(k);
                                // /////////////////////
                                if (cell != null) {
                                    String value = "";
                                    switch (cell.getCellType()) {
                                    case HSSFCell.CELL_TYPE_NUMERIC: // 数值型
                                         if (HSSFDateUtil.isCellDateFormatted(
                                         cell)) {
                                         //如果是date类型则 ，获取该cell的date值
                                         value = HSSFDateUtil.getJavaDate(
                                         cell.getNumericCellValue()).
                                         toString();
                                         out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                         }else{//纯数字
                                        
                                        value = String.valueOf(cell
                                                .getNumericCellValue());
                                        out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                         }
                                        break;
                                    /* 此行表示单元格的内容为string类型 */
                                    case HSSFCell.CELL_TYPE_STRING: // 字符串型
                                        value = cell.getRichStringCellValue()
                                                .toString();
                                        out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                        break;
                                    case HSSFCell.CELL_TYPE_FORMULA://公式型
                                        //读公式计算值
                                         value = String.valueOf(cell.getNumericCellValue());
                                         if(value.equals("NaN")){//如果获取的数据值为非法值,则转换为获取字符串
                                            
                                             value = cell.getRichStringCellValue().toString();
                                         }
                                         //cell.getCellFormula();读公式
                                         out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                    break;
                                    case HSSFCell.CELL_TYPE_BOOLEAN://布尔
                                         value = " "
                                         + cell.getBooleanCellValue();
                                         out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                     break;
                                    /* 此行表示该单元格值为空 */
                                    case HSSFCell.CELL_TYPE_BLANK: // 空值
                                        value = "";
                                        out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                        break;
                                    case HSSFCell.CELL_TYPE_ERROR: // 故障
                                        value = "";
                                        out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                        break;
                                    default:
                                        value = cell.getRichStringCellValue().toString();
                                    out.println("第"+j+"行,第"+k+"列值："+value+"<br>");
                                    }
                                   
                                }
                            }
                        }
                    }
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        out.print("<script>alert('解析完毕');</script>");
        out.flush();
        out.close();
    }
    /**
     * Initialization of the servlet. <br>
     *
     * @throws ServletException
     *             if an error occurs
     */
    public void init() throws ServletException {
        // Put your code here
    }
}
下面是前台jsp页面：

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
   
    <title>My JSP 'index.jsp' starting page</title>
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">   
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
 
  <body>
    This is my JSP page. <br>
    <form action="ReadExcel" method="post">
        上传附件：<input type="file" name="file"><br>
        <input type="submit" value="开始解析">
    </form>
    <br><br><br>
    <form action="ToExcel">
        <input type="submit" value="导出Excel">
    </form>
  </body>
</html>