施用POI对Office Excel 97-2003 版本以及2007版进行基本的读取操作

使用POI对Office Excel 97-2003 版本以及2007版进行基本的读取操作

使用POI对excel不同的版本进行读操作,参见以下代码:

?

import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.ss.util.NumberToTextConverter;import org.apache.poi.xssf.usermodel.XSSFWorkbook;/** * 读取Excel普通数据格式 * @author Jack * 自动识别Office版本 * =>支持Office 97-2003版本 * =>支持Office 2007以上版本 */public class ExcelFactory {private final static MyLog _log = MyLog.getLog(ExcelFactory.class);private String _filepath;// 文件路径(仅限-xls|-xlsx格式)private Workbook _workbook;// Excel工作薄(HSSF*|XSSF*父类)private Sheet _sheet;// Excel工作表private Row _row;// Excel行private Cell _cell;// Excel单元格private int _rows;// Excel已使用的总行数(索引+1)private int _columns;// Excel列数->从配置文件统计出来private int _begin;// Excel开始行->从配置文件中获取private boolean isXLS;// 判断是否是{-xls}private final static String XLSX = ".xlsx";public ExcelFactory(String filepath, int columns, int begin) throws FileNotFoundException, IOException {_filepath = filepath;_columns = columns;_begin = begin;isXLS();get();}private void isXLS() {if (-1 < _filepath.indexOf(XLSX)) {isXLS = true;return ;}isXLS = false;}private Workbook get() throws FileNotFoundException, IOException {if (null == _workbook){_workbook = isXLS?new XSSFWorkbook(_filepath):new HSSFWorkbook(new FileInputStream(_filepath));}return _workbook;}public void Read(int index) {_sheet = _workbook.getSheetAt(index);_rows = _sheet.getLastRowNum();for (int y = _begin; y <= _rows; y ++) {_row = _sheet.getRow(y);if (null == _row){continue;}for (int x = 0; x < _columns; x ++){_cell = _row.getCell(x);if (null == _cell){continue;}String cellValue = getValue(_cell);System.out.print((null == cellValue || 0 == cellValue.length())?"#":cellValue);System.out.print(" ");}System.out.println();}}public String getValue(Cell cell){switch (cell.getCellType()){case Cell.CELL_TYPE_BLANK:return "";case Cell.CELL_TYPE_BOOLEAN:return String.valueOf(cell.getBooleanCellValue());case Cell.CELL_TYPE_ERROR:break;case Cell.CELL_TYPE_FORMULA:return cell.getCellFormula();case Cell.CELL_TYPE_NUMERIC:return NumberToTextConverter.toText(cell.getNumericCellValue());case Cell.CELL_TYPE_STRING:return cell.getStringCellValue();default :return cell.getStringCellValue();}return cell.getStringCellValue();}public static void main(String[] args) throws Exception {//String filepath = "D:/excel/原始订单－liandong110221.xls";//ExcelFactory factory = new ExcelFactory(filepath, 17, 1);//factory.Read(0);String filepath = "D:/excel/test.xlsx";ExcelFactory factory = new ExcelFactory(filepath, 13, 0);factory.Read(0);}}

?