POI解析EXCEL实例

package org.lm.demo.parse;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.Date;
import ermodel.HSSFCell; import ermodel.HSSFDateUtil; import ermodel.HSSFRow; import ermodel.HSSFSheet; import ermodel.HSSFWorkbook;
public class ExcelReader {
private BufferedReader reader = null;
private String filetype;
private InputStream is = null;
private int currSheet;
private int currPosition;
private int numOfSheets;
HSSFWorkbook wb = null;
private static String EXCEL_LINE_DELIMITER = "";
@SuppressWarnings("unused")
private static int MAX_EXCEL_COLUMNS = 64;
public ExcelReader(String inputfile) throws IOException, Exception {
if (inputfile == null || inputfile.trim().equals("")) {
throw new IOException("no input file specified");
}
this.filetype = inputfile.substring(stIndexOf(".") + 1);
currPosition = 0;
currSheet = 0;
is = new FileInputStream(inputfile);
if (filetype.equalsIgnoreCase("txt")) {
reader = new BufferedReader(new InputStreamReader(is));
} else if (filetype.equalsIgnoreCase("xls")) {
wb = new HSSFWorkbook(is);
numOfSheets = wb.getNumberOfSheets();
} else {
throw new Exception("file type not supported");
}
}
public String readLine() throws IOException {
if (filetype.equalsIgnoreCase("txt")) {
String str = reader.readLine();
while (str.trim().equals("")) {
str = reader.readLine();
}
return str;
} else if (filetype.equalsIgnoreCase("xls")) {
HSSFSheet sheet = wb.getSheetAt(currSheet);
if (currPosition > sheet.getLastRowNum()) {
currPosition = 0;
while (currSheet != numOfSheets - 1) {
sheet = wb.getSheetAt(currSheet + 1);
if (currPosition == sheet.getLastRowNum()) {
currSheet++;
continue;
} else {
int row = currPosition;
currPosition++;
return getLine(sheet, row);
}
}
return null;
}
int row = currPosition;
currPosition++;
return getLine(sheet, row);
}
return null;
}
@SuppressWarnings("deprecation")
public String getLine(HSSFSheet sheet, int row) { HSSFRow rowline = sheet.getRow(row);
StringBuffer buffer = new StringBuffer();
int filledColumns = rowline.getLastCellNum();
HSSFCell cell = null;
for (int i = 0; i < filledColumns; i++) {
cell = rowline.getCell((short) i);
String cellvalue = null;
if (cell != null) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC: {
if (HSSFDateUtil.isCellDateFormatted(cell)) {
@SuppressWarnings("unused")
Date date = cell.getDateCellV alue();
cellvalue = cell.getDateCellValue().toLocaleString();
} else {
Integer num = new Integer((int) cell
.getNumericCellValue());
cellvalue = String.valueOf(num);
}
break;
}
case HSSFCell.CELL_TYPE_STRING:
cellvalue = cell.getStringCellValue().replaceAll("'", "''");
break;
default:
cellvalue = " ";
}
} else {
cellvalue = "";
}
buffer.append(cellvalue).append(EXCEL_LINE_DELIMITER);
}
return buffer.toString();
}
public void close() {
if (is != null) {
try {
is.close();
} catch (IOException e) {
is = null;
}
}
if (reader != null) {
try {
reader.close();
} catch (IOException e) {
}
}
}
public static void main(String[] args) {
try {
ExcelReader readexcel = new ExcelReader("D:" + File.separator
+ "test.xls");
String line = readexcel.readLine();
while (line != null) {
System.out.println(line);
line = readexcel.readLine();
}
readexcel.close();
} catch (Exception e) {
System.out.println(e.toString());
}
}
}。