exceltea.java

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

package edu.yinhe.mis.util;

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

import edu.yinhe.mis.dto.PreparelessoncheckDTO;

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

/**
 * 
 * @author 宋玉萍
 * 解析备课记录表
 *
 */
public class ExcelTea {

	Workbook book = null;
	String msg = null;
	Cell cell = null;
	PreparelessoncheckDTO dto = null;

	/**
	 * 解析备课记录表
	 * @param strUrl
	 * @return
	 */
	public ArrayList<PreparelessoncheckDTO> readExcel(String strUrl) {
		ArrayList<PreparelessoncheckDTO> list = new ArrayList<PreparelessoncheckDTO>();
		ToDate td = new ToDate();
		File file = new File(strUrl);
		try {
			book = Workbook.getWorkbook(file);// Excel工作簿
			Sheet sheet = book.getSheet(0);// 在Excel工作表,第一张工作表的缺省索引是0
			for (int i = 5; i < sheet.getRows(); i++) {// sheet.getRows()----行数
				dto = new PreparelessoncheckDTO();
				dto.setTableName(sheet.getCell(0,0).getContents());
				dto.setTableNo(sheet.getCell(2,2).getContents());
				dto.setChecker(sheet.getCell(8,2).getContents());
				for (int j = 0; j < sheet.getColumns(); j++) {// sheet.getColumns()----列数
					cell = sheet.getCell(j, i); // 此处一定要注意坐标，列在前，行在后。
					msg = cell.getContents();
					switch (j) {
					case 0:
						msg = td.toDate(msg);
						dto.setEvaluateDate(msg);
						break;
					case 1:
						dto.setTeacherName(msg);
						break;
					case 2:
						dto.setShouldtimes(msg);
						break;
					case 3:
						dto.setFacttimes(msg);
						break;
					case 4:
						dto.setTeach(msg);
						break;
					case 5:
						dto.setTeachAim(msg);
						break;
					case 6:
						dto.setTeachPlan(msg);
						break;
					case 7:
						dto.setTeachFeedback(msg);
						break;
					case 8:
						dto.setSumscore(Integer.parseInt(msg));
						break;
					case 9:
						dto.setLevel(msg);
						break;
					case 10:
						dto.setEvaluate(msg);
						break;
					}
				}
					list.add(dto);
			}
			book.close();
			file.delete();
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}finally{
			file=null;
		}
		return list;
	}
}