* 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;
}
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());
}
}
}
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
文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
