writeexcel.java

来自「这是一个简单的考试系统」· Java 代码 · 共 39 行

package com.tool;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;

import javax.swing.JTable;

import com.pogo.Grade;

import jxl.Workbook;
import jxl.demo.Write;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class writeExcel {
	public writeExcel(ArrayList list){
		 try {
			WritableWorkbook wwb = Workbook.createWorkbook(new File("files\\grade.xls"));
	        WritableSheet ws = wwb.createSheet("考试成绩",0);
	        ws.addCell( new Label(0,0,"名次"));
	        ws.addCell( new Label(1,0,"姓名"));
	        ws.addCell( new Label(2,0,"成绩"));
	        for(int i=1;i<list.size()+1;i++){
	        	ws.addCell( new Label(0,i,i+""));
	        	ws.addCell( new Label(1,i,((Grade)list.get(i-1)).getName()));
		        ws.addCell( new Label(2,i,((Grade)list.get(i-1)).getGrade()+""));
	        }
	        wwb.write();
	        wwb.close();
		 } catch (Exception e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		 
	}
}