tevaluateexcel.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

package edu.yinhe.mis.control;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import edu.yinhe.mis.dto.TevaluateDTO;
import edu.yinhe.mis.util.ToDate;


public class TevaluateExcel {
	Workbook book=null;
	String msg=null;
	Cell cell=null;
	TevaluateDTO temd=null;

	/**
	 * @author wanjiansheng
	 * @param strUrl
	 * @return list
	 */
	public ArrayList readExcel(String strUrl){
		ArrayList list=new ArrayList();
		File file=new File(strUrl);
		ToDate td = new ToDate();
		try {
			book=Workbook.getWorkbook(file);//Excel工作簿
			Sheet sheet=book.getSheet(0);//在Excel工作表,第一张工作表的缺省索引是0
			for(int i=4;i<sheet.getRows();i++){//sheet.getRows()----行数
				temd=new TevaluateDTO();
				temd.setTableName(sheet.getCell(0, 0).getContents());
				/*System.out.println(sheet.getCell(0, 0).getContents());*/
				//msg = td.toDate(msg);
				temd.setEvaluateTime(td.toDate(sheet.getCell(5, 1).getContents()));
				/*System.out.println(sheet.getCell(5, 1).getContents());*/

				temd.setTableNo(sheet.getCell(8, 1).getContents());
				/*System.out.println(sheet.getCell(8, 1).getContents());*/

				temd.setSubject(sheet.getCell(1, 2).getContents());
				/*System.out.println(sheet.getCell(1, 2).getContents());*/

				temd.setTeacher(sheet.getCell(3, 2).getContents());
				/*System.out.println(sheet.getCell(3, 2).getContents());*/

				temd.setAddScore(sheet.getCell(5, 2).getContents());
				/*System.out.println(sheet.getCell(5, 2).getContents());*/

				temd.setAddReason(sheet.getCell(7, 2).getContents());
				/*System.out.println(sheet.getCell(7, 2).getContents());
				*/
				temd.setFacSore(Integer.parseInt(sheet.getCell(12, 2).getContents()));
				/*System.out.println(sheet.getCell(12, 2).getContents());*/
//				temd.setFacSore(Integer.parseInt(sheet.getCell(9, 2).getContents()));
//				System.out.println(Integer.parseInt(sheet.getCell(9, 2).getContents()));
				/*if(j=0){
					temd.setObservation(msg);
				}*/
				for(int j=0;j<sheet.getColumns();j++){//sheet.getColumns()----列数
					cell=sheet.getCell(j,i); //此处一定要注意坐标，列在前，行在后。
					msg=cell.getContents(); 
					/*if(j==0){
						temd.setObservation(msg);
					}else{*/

					switch(j){
					case 0:temd.setObservation(msg);
					System.out.println(msg);
					break;
					case 10:temd.setScore(msg);
					System.out.println(msg);
					break;
					case 11:temd.setLeval(msg);
					System.out.println(msg);
					break;
					case 12:temd.setAnyScore(msg);
					System.out.println(msg);
					break;
					}
				}
			}
			list.add(temd);
			/*}*/
			book.close(); 
			file.delete();
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} 
		return list;
	}
}