readexcel.java

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

package com.tool;

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

import com.pogo.Grade;

import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class readExcel {

	public static ArrayList run(){
		ArrayList list=new ArrayList();
		try {
			Workbook rwb = Workbook.getWorkbook(new File("files\\grade.xls"));
			Sheet st = rwb.getSheet("考试成绩");
			for(int i=1;i<st.getRows();i++)
			{
				list.add(new Grade(st.getCell(1,i).getContents(),Integer.parseInt(st.getCell(2,i).getContents())));
			}
			rwb.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;		
	}
}