package youg;

import java.io.FileInputStream;
import java.io.InputStream;
import java.util.Vector;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

public class ReadExcel {
	
	//Vector v_identNumber = new Vector(); // ��Ŷ�ȡ�����ĺ���
	
	 
    
    
	public Vector<String> readExcel(String filePath) throws Exception {
		Vector<String> v = new Vector<String>(); // ��Ŷ�ȡ����������͵绰
		InputStream iStream = null;
		Workbook workbook = null;
		iStream = new FileInputStream(filePath);
		workbook = Workbook.getWorkbook(iStream);
		// sheet row column �±궼�Ǵ�0��ʼ��
		Sheet sheet = workbook.getSheet(0);
		int column = sheet.getColumns();
		int rows = sheet.getRows();
		System.out.println("����" + rows + "��" + column + "�����");
		for (int i = 1; i < rows; i++) {
			Cell[] cells = sheet.getRow(i);
			
				//System.out.println(cells[0].getContents());
				v.add(cells[0].getContents());
				v.add(cells[1].getContents());
				//System.out.println(cells[1].getContents());
				//v_identNumber.add(cells[1].getContents());
				//System.out.println(cells[2].getContents());
				//System.out.println(cells[3].getContents());
		}
		// �������ʱ���رն����ͷ�ռ�õ��ڴ�ռ�
		if (iStream != null)
			iStream.close();
		if (workbook != null)
			workbook.close();

		return v;
	}

	/**
	 * @param args
	 * @throws Exception
	 */
//	public static void main(String[] args) throws Exception {
//		String filePath = "D:\\testreadexcel.xls";
//		ReadExcel readExcel = new ReadExcel();
//		readExcel.readExcel(filePath).toString();
//
//	}
}