使用Apache POI和Java获得Excel文件内容，无须MS…

2008-02-23 09:34:49来源：互联网阅读 ()

*
* Created on 2005/07/18
* 使用poi-2.5.1-final-20050804.jar
*/
package com.nova.colimas.common.doc;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import Java.io.FileInputStream;
import java.io.FileOutputStream;
/**
* Deal with Excel Files.
* @author tyrone
*
*/
public class ExcelProcess {

public static String run(String filename){
String text=null;
try{

int sheetnum=0;
HSSFSheet sheet = null;
HSSFRow row=null;
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(filename));
for (sheetnum=0;sheetnum<workbook.getNumberOfSheets();sheetnum ){
sheet = workbook.getSheetAt(sheetnum);
int lastrow=0;
int rownum=0;
lastrow=sheet.getLastRowNum();
for (rownum=0;rownum<lastrow;rownum ){
row = sheet.getRow(rownum);
if (row!=null){
short firstcell=row.getFirstCellNum();
short lastcell=row.getLastCellNum();
short cellnum;
HSSFCell cell=null;
for(cellnum=firstcell;cellnum<lastcell;cellnum ){
cell=row.getCell(cellnum);
if(cell!=null && cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC)
text=text cell.getNumericCellValue();
else if(cell!=null && cell.getCellType()==HSSFCell.CELL_TYPE_STRING){
text=text cell.getStringCellValue();
}
}
text=text "\n";
}
}
}

}catch(Exception e) {
System.out.println(e );
}
return text;
}

/*输入参数为filename.xls
public static void main(String[] args){
try{
FileOutputStream out=new FileOutputStream("resultExcel.txt");
out.write(ExcelProcess.run(args[0]).getBytes());
out.flush();
out.close();
}catch(Exception ex){
System.out.println(ex.toString());
}
}
}

上一篇：使用TextMiniing和Apache POI获得Word文件内容，无须MS-Office ActiveX
下一篇： JBoss 文档（三）——JBoss和JMS

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有