Apache poi教程和例子

package servlet; import java.io.IOException; 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.HSSFCellStyle; 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.hssf.util.Region; public class TestServlet extends HttpServlet { /** * 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 { response.setContentType("text/html"); // PrintWriter out = response.getWriter(); HSSFWorkbook wb=new HSSFWorkbook(); // FileOutputStream fileOut=new FileOutputStream("c:\\a.xls"); //创建一个文件 HSSFSheet sheet=wb.createSheet("new sheet"); //创建一个工作区 HSSFRow row =sheet.createRow((short)0); //创建一行 HSSFCell cell=row.createCell((short)0); // HSSFCell cell1=row.createCell((short)4); cell.setCellValue(1); row.createCell((short)1).setCellValue(1.2); HSSFCell cell2=row.createCell((short)2); cell2.setEncoding(HSSFCell.ENCODING_UTF_16); //改变文字编码 cell2.setCellValue("你好"); HSSFRow row2=sheet.createRow(2); HSSFCell cell20=row2.createCell((short)0); cell20.setCellValue(true); HSSFSheet sheet2=wb.createSheet("new sheet1"); HSSFRow rowx=sheet2.createRow(0); HSSFCell cellx=rowx.createCell((short)0); cellx.setCellValue("aa"); sheet2.addMergedRegion(new Region(0,(short)0,0,(short)2)); sheet2.addMergedRegion(new Region(3,(short)0,5,(short)8)); HSSFRow rowxx=sheet2.createRow(3); HSSFCell cellxx=rowxx.createCell((short)0); cellxx.setCellValue("xxxxx"); HSSFSheet sheet3=wb.createSheet("new sheet2"); sheet3.createFreezePane(1,0); //冻结1列 冻结2行 // sheet3.createFreezePane(3,1,4,2); HSSFRow rowxxx=sheet3.createRow(0); cteatecell(wb,rowxxx,(short)0,HSSFCellStyle.ALIGN_CENTER,"aa"); cteatecell(wb,rowxxx,(short)1,HSSFCellStyle.ALIGN_CENTER,"bb"); cteatecell(wb,rowxxx,(short)2,HSSFCellStyle.ALIGN_LEFT,"cc"); cteatecell(wb,rowxxx,(short)3,HSSFCellStyle.ALIGN_RIGHT,"dd"); request.setAttribute("wb",wb); request.getRequestDispatcher("../download.jsp").forward(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 { doGet(request,response); } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } private static void cteatecell(HSSFWorkbook wb,HSSFRow row,short col,short align,String val) { HSSFCell cell=row.createCell(col); cell.setEncoding(HSSFCell.ENCODING_UTF_16); cell.setCellValue(val); HSSFCellStyle cellstyle=wb.createCellStyle(); cellstyle.setAlignment(align); cell.setCellStyle(cellstyle); } }