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

客官°小女子只卖身不卖艺 2022-08-12 02:59 150阅读 0赞

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();
    			}
    		}
    	}
    }