package com.excelpro.bean;
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.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class ExcelReader extends HttpServlet {
private static final long serialVersionUID = 1L;
public ExcelReader() {
super();
}
public void destroy() {
super.destroy();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("gb2312");
PrintWriter out = response.getWriter();
out.println("");
out.println(" ");
out.println(" ");
String file = request.getParameter("file");
String filePath = "d:\\cnlc\\";
String ext = ".xls";
POIFSFileSystem ps = new POIFSFileSystem(new FileInputStream(filePath+file+ext));//得到excel文件
HSSFWorkbook wb = new HSSFWorkbook(ps);//得到工作薄
for(int w = 0;w < wb.getNumberOfSheets();w++)
{// 循环遍历出每张表
HSSFSheet sheet = wb.getSheetAt(w);//得到工作表
if(sheet.getRow(0) != null)
{//如果表存在但不为空则显示
out.println("工作表: " + wb.getSheetName(w));
}
out.println("
"+cell+" |
}
out.println(" ");
out.println("");
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("");
out.println("");
out.println(" ");
out.println(" ");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the POST method");
out.println(" ");
out.println("");
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}
请