Java通过POI写excel

最新推荐文章于 2025-08-12 21:03:53 发布

dataee

最新推荐文章于 2025-08-12 21:03:53 发布

阅读量83

点赞数

分类专栏： Java 文章标签： java

Java 专栏收录该内容

117 篇文章

订阅专栏

本文介绍如何利用Java的Apache POI库版本3.8来生成Excel文件，具体实现为学生信息统计表。该文详细展示了从定义学生类到填充数据的具体步骤，并最终将数据导出为XLS格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

通过poi(3.8)写xls文件，需求如下：生成学生信息统计表

学生类：

class Student {
	private String name;
	private String gender;
	private int age;
	private String sclass;
	private int score;

	public Student() {
		super();
	}

	public Student(String name, String gender, int age, String sclass, int score) {
		super();
		this.name = name;
		this.gender = gender;
		this.age = age;
		this.sclass = sclass;
		this.score = score;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getGender() {
		return gender;
	}

	public void setGender(String gender) {
		this.gender = gender;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String getSclass() {
		return sclass;
	}

	public void setSclass(String sclass) {
		this.sclass = sclass;
	}

	public int getScore() {
		return score;
	}

	public void setScore(int score) {
		this.score = score;
	}

	@Override
	public String toString() {
		return "Student [age=" + age + ", gender=" + gender + ", name=" + name + ", sclass="
		        + sclass + ", score=" + score + "]";
	}
}

数据准备：

	private static List<Student> studentList = null;
	static {
		studentList = new ArrayList<Student>();
		studentList.add(new Student("张三", "男", 23, "一班", 94));
		studentList.add(new Student("王五", "男", 21, "一班", 87));
		studentList.add(new Student("李四", "女", 20, "一班", 92));
		studentList.add(new Student("赵六", "女", 22, "一班", 83));
	}

具体操作：

	public static void generateExcel(String filePath) {
		// 先创建工作簿对象
		HSSFWorkbook workbook2003 = new HSSFWorkbook();
		// 创建工作表对象并命名
		HSSFSheet sheet = workbook2003.createSheet("学生信息统计表");
		// 遍历集合对象创建行和单元格
		for (int i = 0; i < studentList.size(); i++) {
			// 取出Student对象
			Student student = studentList.get(i);
			// 创建行
			HSSFRow row = sheet.createRow(i);
			// 开始创建单元格并赋值
			HSSFCell nameCell = row.createCell(0);
			nameCell.setCellValue(student.getName());
			HSSFCell genderCell = row.createCell(1);
			genderCell.setCellValue(student.getGender());
			HSSFCell ageCell = row.createCell(2);
			ageCell.setCellValue(student.getAge());
			HSSFCell sclassCell = row.createCell(3);
			sclassCell.setCellValue(student.getSclass());
			HSSFCell scoreCell = row.createCell(4);
			scoreCell.setCellValue(student.getScore());
		}
		// 生成文件
		File file = new File(filePath);
		FileOutputStream fos = null;
		try {
			fos = new FileOutputStream(file);
			workbook2003.write(fos);
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (fos != null) {
				try {
					fos.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
	}

main调用：

	public static void main(String[] args) {
		generateExcel("student.xls");
	}