listenmainexcel.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 java.util.ArrayList;

import edu.yinhe.mis.dto.ListenmainDTO;
import edu.yinhe.mis.util.ToDate;
/**
 * 
 * @author wanjiansheng
 *按.xls的格式解析数据
 *
 */
public class ListenmainExcel {
	Workbook book=null;
	String msg=null;
	Cell cell=null;
	ListenmainDTO listenmainDTO=null;
	
	/**
	 * @author wanjiansheng
	 * @param strUrl
	 * @return list
	 * 解析Excel表提取数据 
	 */
	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=3;i<sheet.getRows();i++){//sheet.getRows()----行数
				listenmainDTO=new ListenmainDTO();
				listenmainDTO.setTableName(sheet.getCell(0, 0).getContents());
				//System.out.println(sheet.getCell(0, 0).getContents());				
				listenmainDTO.setTableNo(sheet.getCell(5, 1).getContents());				
				//System.out.println(sheet.getCell(5, 1).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);
					    listenmainDTO.setListenDate(msg);
					   /* System.out.println(j);
					    System.out.println(i);
					    System.out.println(msg);*/
					    break;
					    
					    case 1:listenmainDTO.setClassNo(msg); 
					  /*  System.out.println(msg);*/
					    break;
					    
					    case 2:listenmainDTO.setClassroomName(msg);
					  /*  System.out.println(msg);*/
					    break;
					    case 3:listenmainDTO.setTeacher(msg); 
					   /* System.out.println(msg);*/
					    break;
					    case 4:listenmainDTO.setStudentNum(msg); 
					    /*System.out.println(msg);*/
					    break;
					    case 5:listenmainDTO.setContent(msg);
					    /*System.out.println(msg);*/
					    break;
					    case 6:listenmainDTO.setAppraise(msg); 
					   /* System.out.println(msg);*/
					    break;
					    case 7:listenmainDTO.setGeneralcomment(msg);
					   /* System.out.println(msg);*/
					    break;
					    case 8:listenmainDTO.setContentmentscore(msg); 
					    /*System.out.println(msg);*/
					    break;
					    case 9:listenmainDTO.setListener(msg);
					   /* System.out.println(msg);*/
					    break;
					   
					}
				}
				list.add(listenmainDTO);
			}
			book.close(); 
			file.delete();
		} catch (BiffException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} finally{
			file=null;
		}
		return list;
	}
}