// 读取Excel的类

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileWriter;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

public class ExcelTest01 {

	public static void main(String args[]) {

		try {

			System.out.println("begini");

			Workbook book = Workbook.getWorkbook(new File("a.xls"));

			// 获得第一个工作表对象

			Sheet sheet = book.getSheet(0);

			// 得到第一列第一行的单元格

			try {

				File file = new File("c:/IAI.txt");

				if (file.exists()) {

					file.delete();

				}

				file.createNewFile();

				BufferedWriter output = new BufferedWriter(new FileWriter(file));

				for (int i = 2; i < 4896; i++) {

					Cell cell1 = sheet.getCell(23, i);// PH

					Cell cell2 = sheet.getCell(4, i);// 省

					Cell cell3 = sheet.getCell(7, i);// 县

					Cell cell4 = sheet.getCell(8, i);// 乡

					Cell cell5 = sheet.getCell(9, i);// 村

					Cell cell6 = sheet.getCell(10, i);// 组

					String ph = cell1.getContents();

					String sheng = cell2.getContents();

					String xian = cell3.getContents();

					String xiang = cell4.getContents();

					String cun = cell5.getContents();

					String zu = cell6.getContents();

					System.out.println("第" + (i + 1) + "行" + sheng + xian + xiang

							+ cun + zu+"\t"+ph);

					output.write("第" + (i + 1) + "行" + sheng + xian + xiang

							+ cun + zu+"\t"+ph+"\n");

					output.newLine();

				}

				output.close();

			} catch (Exception ex) {

				System.out.println(ex);

			}

			book.close();

			System.out.println("end");

		} catch (Exception e) {

			System.out.println(e);

		}

	}

}