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

来源：互联网发布：制衣软件编辑：程序博客网时间：2024/06/05 05:33
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();}}}}
0 0