struts2+poi和struts2+jxl实现读取EXCEL

今天花了半个小时，研究struts2通过第三方插件读取EXCEL功能，今贴出来，希望对网友们有用，默认的execute方法中，使用poi读取，read方法中使用jxl读取

package example;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.opensymphony.xwork2.ActionSupport;


public class ExcelAction extends ActionSupport {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	private File excel;
	
	public File getExcel() {
		return excel;
	}
	public void setExcel(File excel) {
		this.excel = excel;
	}
	@Override
	public String execute() throws Exception {
		try{
			InputStream is = new FileInputStream(excel);
			HSSFWorkbook work = new HSSFWorkbook(is);
			HSSFSheet sheet = work.getSheetAt(0);
			if(sheet != null){
				int rows = sheet.getPhysicalNumberOfRows();
				for(int i = 0;i < rows;i++){
					HSSFRow row = sheet.getRow(i);
					for(int j = 0;j<row.getPhysicalNumberOfCells();j++){
						HSSFCell cell = row.getCell(j);
						if(HSSFCell.CELL_TYPE_STRING == cell.getCellType()){
							System.out.println("字符串："+cell.getRichStringCellValue());
						}else if(HSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()){
							System.out.println("数字："+cell.getNumericCellValue());
						}
					}
				}
			}
			
			if(is != null){
				is.close();
			}
		}catch(Exception e){
			LOG.error("上传错误", e);
		}
		return SUCCESS;
	}

	public String read() throws Exception{
		Workbook wb = null;
        try {
        	InputStream is = new FileInputStream(excel);
            wb = Workbook.getWorkbook(is);
            Sheet[] sheets = wb.getSheets();    //获取工作 
            for(int i=0; i<sheets.length; i++) {
                Sheet sheet = sheets[i];
                for(int j=0; j<sheet.getRows(); j++) {
                    Cell[] cells = sheet.getRow(j);    //读取一列 
                    if(cells != null && cells.length > 0) {   
                        String[] dataCells = new String[cells.length];
                        for(int k=0; k<cells.length; k++) {
                            dataCells[k] = ""+cells[k].getContents();
                            System.out.println(cells[k].getContents());
                        }//column
                    }
                }//one sheet
            }//xls file
        } catch (BiffException e) {
            e.printStackTrace();
        } catch (IOException e) {    
            e.printStackTrace();
        } finally {
            if(wb != null) {
                wb.close();
            }
        }

		return SUCCESS;
	}
	
}

评论

3 楼 cqyqing 2012-11-14  

向往前途 写道

在Struts2.xml文件怎么配置啊

<constant name="struts.objectFactory" value="spring"/>
    <constant name="struts.enable.DynamicMethodInvocation" value="true" />
    <constant name="struts.devMode" value="false" />
    <constant name="struts.i18n.encoding" value="GBK" />
    <constant name="struts.multipart.maxSize" value="209715200" /><!-- 200M -->
    <constant name="struts.multipart.saveDir" value="/tmp"/>

<package name="default" extends="struts-default" namespace="/">
<action name="*_*" class="{1}" method="{2}">
<result>index.jsp</result>
<result name="list">/upload.jsp</result>
<result name="mail">/mail.jsp</result>
<result name="db">/db.jsp</result>
<result name="{2}">/{2}.jsp</result>
</action>
</package>

注意红色字体配置就可以了

2 楼 向往前途 2012-11-10  

在Struts2.xml文件怎么配置啊

1 楼 66573334 2010-08-23  

正好用到顶起