ExcelReader类

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;

/**
 *  
 *jxl操作excel包括对象Workbook,Sheet,Cell
 *一个excel就对应一个Workbook对象，
 *一个Workbook可以有多个Sheet对象
 *一个Sheet对象可以有多个Cell对象
 * @author Matrix42
 *
 */
public class ExcelReader {
	
	private File excelFile;
	private Workbook workbook;
	private Sheet sheet;
	private int sheetNumber;
	
	//可以用String或File构造一个ExcelReader对象
	public ExcelReader(String filePath,int sheetNumber){
		this.excelFile = new File(filePath);
		this.sheetNumber = sheetNumber;
	}
	
	public ExcelReader(File excelFile,int sheetNumber){
		this.excelFile = excelFile;
		this.sheetNumber = sheetNumber;
	}
	
	//初始化
	public void init() throws BiffException, IOException{
		this.workbook = Workbook.getWorkbook(excelFile);
		this.sheet = workbook.getSheet(sheetNumber);
	}
	
	//获取columnNumber列的所有行,两个重载
	//取一个区间内的
	public ArrayList<String> getColumns(int columnNumber,int start,int end){
		int rows = sheet.getRows();
		int columns = sheet.getColumns();
		if(columns<0||columnNumber>columns-1){
			throw new IllegalArgumentException("column not in range!");
		}
		if(start<0||end>rows-1){
			throw new IllegalArgumentException("row not in range!");
		}
		ArrayList<String> list = new ArrayList<String>();
		for(int i=start;i<=end;i++){
			Cell cell = sheet.getCell(columnNumber,i);
			list.add(cell.getContents());
		}
		return list;
	}
	
	//从start到最后
	public ArrayList<String> getColumns(int columnNumber,int start){
		int rows = sheet.getRows();
		int columns = sheet.getColumns(); 
		int end = rows - 1;
		if(columns<0||columnNumber>columns-1){
			throw new IllegalArgumentException("column not in range!");
		}
		if(start<0){
			throw new IllegalArgumentException("row not in range!");
		}
		ArrayList<String> list = new ArrayList<String>();
		for(int i=start;i<=end;i++){
			Cell cell = sheet.getCell(columnNumber,i);
			list.add(cell.getContents());
		}
		return list;
	}
	
}

public class Time {
	private int d;
	private int h;
	private int m;
	private int s;
	
	//解析出天,时,分,秒,与之前的结果相加
	public void add(String time) {
		int indexOfDay = time.indexOf("天");
		int indexOfHour = time.indexOf("时");
		int indexOfMinute = time.indexOf("分");
		int indexOfSecond = time.indexOf("秒");
		
		if(indexOfDay>0){
			d += Integer.parseInt(time.substring(0,indexOfDay));
		}
		if(indexOfHour>0){
			if(indexOfDay>0){
				h += Integer.parseInt(time.substring(indexOfDay+1,indexOfHour));
			}else {
				h += Integer.parseInt(time.substring(0,indexOfHour));
			}
		}
		if(indexOfMinute>0){
			if(indexOfHour>0){
				m += Integer.parseInt(time.substring(indexOfHour+1,indexOfMinute));
			}else {
				m += Integer.parseInt(time.substring(0,indexOfMinute));
			}
		}
		if(indexOfSecond>0){
			if(indexOfMinute>0){
				s += Integer.parseInt(time.substring(indexOfMinute+1,indexOfSecond));
			}else {
				s += Integer.parseInt(time.substring(indexOfMinute+1,indexOfSecond));
			}
		}
	}
	
	//转换时间
	public String format(){
		int tmp;
		
		tmp = s/60;
		s %= 60;
		
		m = m + tmp;
		tmp = m/60;
		m %= 60;
		
		h = h + tmp;
		tmp = h/24;
		h %= 24;
		
		d = d + tmp;
		
		String t = "";
		if(d!=0){
			t += d+"天";
		}
		if(h!=0){
			t += h+"时";
		}
		if(m!=0){
			t += m+"分";
		}
		if(s!=0){
			t += s+"秒";
		}
		return t;
	}

	public int getD() {
		return d;
	}

	public int getH() {
		return h;
	}

	public int getM() {
		return m;
	}

	public int getS() {
		return s;
	}
	
}

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

import jxl.read.biff.BiffException;

public class Client {

	public static void main(String[] args) throws BiffException, IOException {

		//读取第1个Sheet
		ExcelReader reader = new ExcelReader("D:/01.xls", 0);
		reader.init();
		//读取第4列
		ArrayList<String> result = reader.getColumns(3, 1);
		Time time = new Time();
		//把时间加一起
		for (String string : result) {
			time.add(string);
		}
		System.out.println("您的通话总时长为:"+time.format()+"!");
	}

}