Excel Handle by org.apache.poi.xssf.usermodel.*

package shuai.study.excel.xssf;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * @ClassName: ExcelHandle
 * @Description: Excel Handle
 * @author Zhou Shengshuai
 * @date 2014年9月17日 下午12:57:22
 * 
 */
public class ExcelHandle {
	private String filePath = null;

	public void setFilePath(String filePath) {
		this.filePath = filePath;
	}

	public void initialize() {
		this.excelRead();
	}

	public void destroy() {
	}

	public void excelRead() {
		File file = new File(filePath);

		if (file != null && file.exists()) {
			this.excelRead(file);
		}
	}

	private void excelRead(File file) {
		InputStream inputStream = null;

		try {
			inputStream = new FileInputStream(file);
			XSSFWorkbook xssfWorkbook = new XSSFWorkbook(new BufferedInputStream(inputStream, 65536));

			this.excelRead(xssfWorkbook);
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	private void excelRead(XSSFWorkbook xssfWorkbook) {
		for (int index = 0; index < xssfWorkbook.getNumberOfSheets(); index++) {
			XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(index);

			this.excelRead(xssfSheet);
		}
	}

	private void excelRead(XSSFSheet xssfSheet) {
		XSSFCell xssfCell = null;
		XSSFRow xssfRow = null;

		for (int row = 1; row < xssfSheet.getLastRowNum(); row++) {
			xssfRow = xssfSheet.getRow(row);

			if (xssfRow != null) {
				for (int cell = 0; cell < xssfRow.getLastCellNum(); cell++) {
					xssfCell = xssfRow.getCell(cell);

					if (xssfCell != null) {
						System.out.print(xssfCell.toString() + "\t");
					} else {
						System.out.print("--" + "\t");
					}
				}

				System.out.println();
			}
		}
	}
}