excelquality.java

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

package edu.yinhe.mis.util;

import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import edu.yinhe.mis.dto.QualityMainDTO; //import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

/**
 * 
 * @author 熊星
 * 
 * 解析Excel表格
 * 
 * 注释的为测试代码
 */
public class ExcelQuality {

	public  ArrayList<QualityMainDTO> readExcel(String strUrl) {

		Workbook book = null;
		QualityMainDTO dto = null;
		ArrayList<QualityMainDTO> list = new ArrayList<QualityMainDTO>();
		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()----行数
			SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
			dto = new QualityMainDTO();
			//Integer mes56 = Integer.getInteger(sheet.getCell(4, 17).getContents());
			dto.setTableName(sheet.getCell(0, 0).getContents());
			dto.setTableNo(sheet.getCell(0, 1).getContents());
			dto.setScore(sheet.getCell(1, 4).getContents());
			dto.setScore(sheet.getCell(1, 9).getContents());
			dto.setScore(sheet.getCell(1, 15).getContents());
			dto.setScore(sheet.getCell(1, 16).getContents());
			dto.setBehave(sheet.getCell(0, 4).getContents());
			dto.setBehave(sheet.getCell(2, 4).getContents());
			dto.setScoreWay(sheet.getCell(3, 4).getContents());
			dto.setScoreWay(sheet.getCell(3, 5).getContents());
			dto.setScoreWay(sheet.getCell(3, 6).getContents());
			dto.setFactScore(sheet.getCell(4, 4).getContents());
			dto.setFactScore(sheet.getCell(4, 9).getContents());
			dto.setSumScore(Integer.parseInt(sheet.getCell(4, 17).getContents()));
			// dto.setSumScore(92);
			dto.setExplain(sheet.getCell(5, 4).getContents());
			dto.setExplain(sheet.getCell(5, 9).getContents());
			dto.setTeacherName(sheet.getCell(1, 2).getContents());
			dto.setDepartmentName(sheet.getCell(3, 2).getContents());
			dto.setChecker(sheet.getCell(5, 2).getContents());
			dto.setCheckTime(sf.format(new Date()));
			/*String mes = sheet.getCell(0, 0).getContents();
			String mes1 = sheet.getCell(0, 1).getContents();
			String mes2 = sheet.getCell(0, 2).getContents();
			String mes3 = sheet.getCell(1, 2).getContents();
			String mes4 = sheet.getCell(2, 2).getContents();
			String mes5 = sheet.getCell(3, 2).getContents();
			String mes6 = sheet.getCell(4, 2).getContents();
			String mes7 = sheet.getCell(5, 2).getContents();
			String mes8 = sheet.getCell(0, 3).getContents();
			String mes9 = sheet.getCell(1, 3).getContents();
			String mes10 = sheet.getCell(2, 3).getContents();
			String mes12 = sheet.getCell(4, 3).getContents();
			String mes13 = sheet.getCell(5, 3).getContents();
			String mes14 = sheet.getCell(0, 4).getContents();
			String mes15 = sheet.getCell(1, 4).getContents();
			String mes16 = sheet.getCell(2, 4).getContents();
			String mes17 = sheet.getCell(3, 4).getContents();
			String mes18 = sheet.getCell(4, 4).getContents();
			String mes19 = sheet.getCell(5, 4).getContents();
			String mes20 = sheet.getCell(2, 5).getContents();
			String mes21 = sheet.getCell(3, 5).getContents();
			String mes22 = sheet.getCell(2, 6).getContents();
			String mes23 = sheet.getCell(3, 6).getContents();
			String mes24 = sheet.getCell(2, 7).getContents();
			String mes25 = sheet.getCell(3, 7).getContents();
			String mes26 = sheet.getCell(2, 8).getContents();
			String mes27 = sheet.getCell(3, 8).getContents();
			String mes28 = sheet.getCell(0, 9).getContents();
			String mes29 = sheet.getCell(1, 9).getContents();
			String mes30 = sheet.getCell(2, 9).getContents();
			String mes31 = sheet.getCell(3, 9).getContents();
			String mes32 = sheet.getCell(4, 9).getContents();
			String mes33 = sheet.getCell(5, 9).getContents();
			String mes34 = sheet.getCell(2, 10).getContents();
			String mes35 = sheet.getCell(3, 10).getContents();
			String mes36 = sheet.getCell(2, 11).getContents();
			String mes37 = sheet.getCell(3, 11).getContents();
			String mes38 = sheet.getCell(2, 12).getContents();
			String mes39 = sheet.getCell(3, 12).getContents();
			String mes40 = sheet.getCell(2, 13).getContents();
			String mes41 = sheet.getCell(3, 13).getContents();
			String mes42 = sheet.getCell(2, 14).getContents();
			String mes43 = sheet.getCell(3, 14).getContents();
			String mes44 = sheet.getCell(0, 15).getContents();
			String mes45 = sheet.getCell(1, 15).getContents();
			String mes46 = sheet.getCell(2, 15).getContents();
			String mes47 = sheet.getCell(3, 15).getContents();
			String mes48 = sheet.getCell(4, 15).getContents();
			String mes49 = sheet.getCell(5, 15).getContents();
			String mes50 = sheet.getCell(0, 16).getContents();
			String mes51 = sheet.getCell(1, 16).getContents();
			String mes52 = sheet.getCell(2, 16).getContents();
			String mes53 = sheet.getCell(4, 16).getContents();
			String mes54 = sheet.getCell(5, 16).getContents();
			String mes55 = sheet.getCell(0, 17).getContents();
			 String mes56 = sheet.getCell(4, 17).getContents();
			String mes57 = sheet.getCell(5, 17).getContents();
			String mes58 = sheet.getCell(0, 18).getContents();
			String mes59 = sheet.getCell(2, 18).getContents();
			String mes60 = sheet.getCell(3, 18).getContents();
			String mes61 = sheet.getCell(5, 18).getContents();
			System.out.println("mes=" + mes);
			System.out.println("mes1=" + mes1);
			System.out.println("mes2=" + mes2);
			System.out.println("mes3=" + mes3);
			System.out.println("mes4=" + mes4);
			System.out.println("mes5=" + mes5);
			System.out.println("mes6=" + mes6);
			System.out.println("mes7=" + mes7);
			System.out.println("mes8=" + mes8);
			System.out.println("mes9=" + mes9);
			System.out.println("mes10=" + mes10);
			System.out.println("mes12=" + mes12);
			System.out.println("mes13=" + mes13);
			System.out.println("mes14=" + mes14);
			System.out.println("mes15=" + mes15);
			System.out.println("mes16=" + mes16);
			System.out.println("mes17=" + mes17);
			System.out.println("mes18=" + mes18);
			System.out.println("mes19=" + mes19);
			System.out.println("mes20=" + mes20);
			System.out.println("mes21=" + mes21);
			System.out.println("mes22=" + mes22);
			System.out.println("mes23=" + mes23);
			System.out.println("mes24=" + mes24);
			System.out.println("mes25=" + mes25);
			System.out.println("mes26=" + mes26);
			System.out.println("mes27=" + mes27);
			System.out.println("mes28=" + mes28);
			System.out.println("mes29=" + mes29);
			System.out.println("mes30=" + mes30);
			System.out.println("mes31=" + mes31);
			System.out.println("mes32=" + mes32);
			System.out.println("mes33=" + mes33);
			System.out.println("mes34=" + mes34);
			System.out.println("mes35=" + mes35);
			System.out.println("mes36=" + mes36);
			System.out.println("mes37=" + mes37);
			System.out.println("mes38=" + mes38);
			System.out.println("mes39=" + mes39);
			System.out.println("mes40=" + mes40);
			System.out.println("mes41=" + mes41);
			System.out.println("mes42=" + mes42);
			System.out.println("mes43=" + mes43);
			System.out.println("mes44=" + mes44);
			System.out.println("mes45=" + mes45);
			System.out.println("mes46=" + mes46);
			System.out.println("mes47=" + mes47);
			System.out.println("mes48=" + mes48);
			System.out.println("mes49=" + mes49);
			System.out.println("mes50=" + mes50);
			System.out.println("mes51=" + mes51);
			System.out.println("mes52=" + mes52);
			System.out.println("mes53=" + mes53);
			System.out.println("mes54=" + mes54);
			System.out.println("mes55=" + mes55);
			System.out.println("mes56=" + mes56);
			System.out.println("mes57=" + mes57);
			System.out.println("mes58=" + mes58);
			System.out.println("mes59=" + mes59);
			System.out.println("mes60=" + mes60);
			System.out.println("mes61=" + mes61);*/
			// 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:
			 * 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; } } list.add(dto); }
			 */

			book.close();
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			file.delete();
		}
		list.add(dto);
		return list;
	}
	// 测试代码
	
	/* public static void main(String[] args) {
	  ExcelQuality.readExcel("d:\\test.xls"); }*/
	 

}