//实体类
package com.outxls;

public class Student {

	private Integer studentId;

	private String  studentName;

	private String 	studentClass;

	private String 	studentTel;

	private String  studentEmail;

	public Integer getStudentId() {

		return studentId;

	}

	public void setStudentId(Integer studentId) {

		this.studentId = studentId;

	}

	public String getStudentName() {

		return studentName;

	}

	public void setStudentName(String studentName) {

		this.studentName = studentName;

	}

	public String getStudentClass() {

		return studentClass;

	}

	public void setStudentClass(String studentClass) {

		this.studentClass = studentClass;

	}

	public String getStudentTel() {

		return studentTel;

	}

	public void setStudentTel(String studentTel) {

		this.studentTel = studentTel;

	}

	public String getStudentEmail() {

		return studentEmail;

	}

	public void setStudentEmail(String studentEmail) {

		this.studentEmail = studentEmail;

	}

	public Student(Integer studentId, String studentName, String studentClass, String studentTel, String studentEmail) {

		super();

		this.studentId = studentId;

		this.studentName = studentName;

		this.studentClass = studentClass;

		this.studentTel = studentTel;

		this.studentEmail = studentEmail;

	}

	public Student() {

		super();

	}

	@Override

	public String toString() {

		return "Student [studentId=" + studentId + ", studentName=" + studentName + ", studentClass=" + studentClass

				+ ", studentTel=" + studentTel + ", studentEmail=" + studentEmail + "]";

	}

}

package com.outxls;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStream;

import java.util.ArrayList;

import java.util.List;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class OutXlsUtil {

	public static void main(String[] args) {

		//省去数据库查询代码  ，所有我自己直接写了一个集合代替查询到的数据

		List<Student> stulist=new ArrayList<Student>();

		Student stu=null;

		for(int i=0;i<10;i++) {

			stu=new Student();

			stu.setStudentId(i+1);

			stu.setStudentName("小明"+(i+1));

			stu.setStudentClass("一班");

			stu.setStudentTel("1337098123"+i);

			stu.setStudentEmail("7632832"+i+"@qq.com");

			stulist.add(stu);

		}

		try {

			outFilesUtil(stulist);

		} catch (RowsExceededException e) {

			e.printStackTrace();

		} catch (WriteException e) {

			e.printStackTrace();

		} catch (IOException e) {

			e.printStackTrace();

		}

	}

	/**

	 *

	 * @param stulist 传一个集合

	 * @throws IOException

	 * @throws RowsExceededException

	 * @throws WriteException

	 */

	public static void outFilesUtil(List<Student> stulist) throws IOException, RowsExceededException, WriteException {

		//用一个string 数组来设置xls表头

		String[] title = { "序号", "姓名", "班级", "手机号码", "邮箱" };

		// 创建一个输出的xls文件路径

		String outPath = "C:\\Student.xls";

		// 创建Excel 工作

		WritableWorkbook wwb;

		OutputStream os = null;

		//输出流

		os = new FileOutputStream(outPath);

		wwb = Workbook.createWorkbook(os);

		// 添加第一个工作表并设置第一个Sheet的名字

		WritableSheet sheet = wwb.createSheet("学生信息", 0);

		Label label;

		for (int i = 0; i < title.length; i++) {

			//设置表头

			label = new Label(i, 0, title[i]);

			sheet.addCell(label);

		}

		// 这里是将查询的数据填写到xls表

		for (int j = 0; j < stulist.size(); j++) {

			//1 列

			label = new Label(0, j + 1, stulist.get(j).getStudentId().toString());

			sheet.addCell(label);

			//2 列

			label = new Label(1, j + 1, stulist.get(j).getStudentName());

			sheet.addCell(label);

			//3 列

			label = new Label(2, j + 1, stulist.get(j).getStudentClass());

			sheet.addCell(label);

			//4 列

			label = new Label(3, j + 1, stulist.get(j).getStudentTel());

			sheet.addCell(label);

			//5 列

			label = new Label(4, j + 1, stulist.get(j).getStudentEmail());

			sheet.addCell(label);

		}

		// 写入数据

		wwb.write();

		//刷新

		os.flush();

		// 关闭文件

		wwb.close();

	}

}