JAVA读取Excel中的数据

先去下载个JXL的JAR包。以下是一个小例子。

package test.hello;

import java.io.File;
import java.io.IOException;

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

public class JXLTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			//得到工作薄
			Workbook workbook = Workbook.getWorkbook(new File("D:/mydata.xls"));
			//得到工作区
			Sheet sheet = workbook.getSheet(0);
			//得到单元格
			Cell cell00 = sheet.getCell(0,0);
			Cell cell01 = sheet.getCell(0,1);
			Cell cell02 = sheet.getCell(0,2);
			
			//得到列数
			int columCount = sheet.getColumns();
			//得到行数
			int rowCount = sheet.getRows();
			
			System.out.println("行数"+columCount);
			System.out.println("列数"+rowCount);
			
			for(int i=0;i<rowCount;i++){
				System.out.print("第"+(i+1)+"行的内容是:");
				for(int j=0;j<columCount;j++){
					Cell cell = sheet.getCell(j,i);				
					System.out.print(cell.getContents()+"\t");
				}
				System.out.println("");
			}	
			
		} catch (BiffException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}