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();
}
}
}
}
Excel Handle by org.apache.poi.xssf.usermodel.*
最新推荐文章于 2024-05-27 14:28:54 发布