java中对excel数据导出的通用类

excel数据的导出作为业务系统的通用功能，excel中最普遍的一个方法便是将内存中的几何对象转化为excel的数据表格，

本实例是一个针对不同类型的java类的一个通用转换方法。

package com.taobao.psi.goods.service.impl;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.commons.beanutils.BeanUtils;
import org.apache.commons.beanutils.PropertyUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
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 org.apache.poi.poifs.filesystem.POIFSFileSystem;
import com.taobao.psi.goods.dto.SkuDO;
import com.taobao.psi.goods.dto.SkuDOEx;
import com.taobao.psi.simple.SimpleSkuDO;
import com.taobao.util.CollectionUtil;


public class SimGoodsListGenExcel {

DecimalFormat df1 = new DecimalFormat("####.00");
private HSSFWorkbook wb = null;
private static final Log log = LogFactory.getLog(SimGoodsListGenExcel.class);
private HSSFSheet sheet1 = null;
private int rowIndex = 0;
private HSSFRow row = null;
private HSSFCell cell = null;
private static final List<String> colllist = new ArrayList<String>();
private static final List<String> nameList = new ArrayList<String>();
private boolean viewCostPrice = true;

private Long tbAuctionId;//商品ID

private Integer realInvCount;//实际库存数量

private Long cost;//成本价格

private String property; //规格

private String auctionCode;//商家编码

private String goodsName;//商品名称

private Long salesPrice;
 


static {
colllist.add("goodsName");
colllist.add("auctionCode");
colllist.add("property");
colllist.add("cost");
colllist.add("realInvCount");
nameList.add("商品名称");
nameList.add("商品编码");
nameList.add("规格");
nameList.add("成本价");
nameList.add("当前库存");
}

public SimGoodsListGenExcel( ) {
this.viewCostPrice = viewCostPrice;
wb = new HSSFWorkbook();
sheet1 = wb.createSheet("goodsList");
row = sheet1.createRow(rowIndex);
rowIndex++;
for (int j = 0; j < nameList.size(); j++) {
cell = row.createCell((short)j);
cell.setCellValue(nameList.get(j));
}
}


public void setContent(List<SimpleSkuDO> simskuList) {
if (CollectionUtil.isNotEmpty(simskuList)) {
for (SimpleSkuDO dto : simskuList) {
row = sheet1.createRow(rowIndex);
rowIndex++;
for (int i = 0; i < colllist.size(); i++) {
String name = colllist.get(i);
cell = row.createCell((short)i);
try {
if(name.equals("cost")){
cell.setCellValue(df1.format(Double.parseDouble(PropertyUtils.getProperty(dto, name).toString())/100));
}else{
cell.setCellValue(PropertyUtils.getProperty(dto, name).toString());
}

} catch (Exception e) {


}
}
}
}
}


public byte[] getResult() {
ByteArrayOutputStream os = new ByteArrayOutputStream();
POIFSFileSystem fs = new POIFSFileSystem();
try {
fs.createDocument(new ByteArrayInputStream(wb.getBytes()), "Workbook");
fs.writeFilesystem(os);
byte[] buff = os.toByteArray();
return buff;
} catch (IOException e) {
log.error("IOException", e);
} finally {
try {
os.close();
} catch (IOException e) {
}
}
return null;
}
}