将数据导入到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}}