使用poi创建表，HSSFWorkbook，HSSFSheet，HSSFRow

实现代码：

package com.classify.servlet;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Set;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.swing.JOptionPane;

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;
import org.apache.poi.ss.util.CellRangeAddress;


public class DoGoodsPrint extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public DoGoodsPrint() {
		super();
		// TODO Auto-generated constructor stub
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// 设置字符集
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/html;charset=utf-8");
		
		String filePath = "C:\\Users\\Administrator\\Desktop\\admin.xls";// 文件路径
		HSSFWorkbook workbook = new HSSFWorkbook();// 创建Excel文件(Workbook)
		HSSFSheet sheet = workbook.createSheet();// 创建工作表(Sheet)
		sheet = workbook.createSheet(string);// 创建工作表(Sheet)

		HSSFRow row = sheet.createRow(0);// 创建行,从0开始
		// 合并列
		HSSFCell cell = row.createCell(0);
		cell.setCellValue("商品查询结果");
		CellRangeAddress region = new CellRangeAddress(0, 0, 0, 5);
		sheet.addMergedRegion(region);

		row = sheet.createRow(1);
		cell = row.createCell(0);// 创建行的单元格,也是从0开始
		cell.setCellValue("编号");// 设置单元格内容
		row.createCell(1).setCellValue("用户名");// 设置单元格内容,重载
		row.createCell(2).setCellValue("密码");// 设置单元格内容,重载
		row.createCell(3).setCellValue("联系方式");// 设置单元格内容,重载
		row.createCell(4).setCellValue("登录身份");// 设置单元格内容,重载

		for (int i = 0; i < 6; i++) {
			row = sheet.createRow(i + 2);
			row.createCell(1).setCellValue("111");// 设置单元格内容,重载
			row.createCell(2).setCellValue("112");// 设置单元格内容,重载
			row.createCell(3).setCellValue("113");// 设置单元格内容,重载
			row.createCell(4).setCellValue("114");// 设置单元格内容,重载
			row.createCell(0).setCellValue("115");// 设置单元格内容,重载
		}

		FileOutputStream out = new FileOutputStream(filePath);
		workbook.write(out);// 保存Excel文件
		out.close();// 关闭文件流
		System.out.println("OK!");
		JOptionPane.showMessageDialog(null, "打印完成..");
			}

		} else {
			PrintWriter out = response.getWriter();
			out.flush();
			out.println("<script>");
			out.println("alert('操作失败，请输入要查询的关键词');");
			out.println("history.back();");
			out.println("</script>");
		}

		// 请求转发
		response.sendRedirect("admin_dogoodsselect?cur_user=" + cur_user);
	}
}

jar包在我上传的资源里面