将数据导入到Excel文件

//需要poi.jar

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

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;

public class ExportExcel extends HttpServlet {
	private static final long serialVersionUID = 1L;
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		 HSSFWorkbook wb = new HSSFWorkbook();
		 HSSFSheet sheet = wb.createSheet("Sheet1");
	     HSSFRow row = sheet.createRow(0);
	     HSSFCell cell;
	     
	     String[] header = new String[]{"FirstName","LastName", "Birthday", "Province"};
	     
	     for(int i = 0; i <  header.length; i++){
	    	 cell = row.createCell(i);
	    	 cell.setCellValue(header[i]);
	     }
	     
	     response.setContentType("application/ms-excel;charset=GBK");
		 response.setHeader("Content-disposition", "attachment; filename=test.xls");
	     OutputStream out = response.getOutputStream();
//	     String outputFile="e:/test.xls"; 
//	     FileOutputStream out = new FileOutputStream(outputFile); 
	     wb.write(out);
	     out.flush();
	     out.close();
	     System.out.println("文件生成..."); 
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}
}