nc自定义导出功能

nc自定义导出功能

package nc.ui.ic.sapplymodify.action;

import java.awt.event.ActionEvent;
import java.util.List;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import nc.ui.pubapp.uif2app.model.BillManageModel;
import nc.ui.pubapp.uif2app.view.ShowUpableBillForm;
import nc.ui.pub.bill.BillCardPanel;
import nc.ui.pub.beans.MessageDialog;
import nc.ui.uif2.NCAction;
import nc.ui.pub.bill.BillItem;
import nc.vo.ic.sapplymodify.AggSapplyModifyHVO;
import nc.vo.ic.sapplymodify.SapplyModifyHVO;
import nc.vo.pub.BusinessException;
import nc.hr.utils.ResHelper;
import javax.swing.JFileChooser;
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import nc.pub.templet.converter.util.helper.ExceptionUtils;

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


public class ExportAction extends NCAction{
	
	private static final long serialVersionUID = 1L;
	private BillManageModel model;
	private ShowUpableBillForm editor;
	protected static JFileChooser m_chooser = null;
	public String strFileName;
	
	public ExportAction() {
		super();
		this.setBtnName("导出Excel");
		this.setCode("BtnExport");
	}
	
	@Override
	public void doAction(ActionEvent e) throws Exception {
		List<AggSapplyModifyHVO> aggvolist = getModel().getData();
		if(aggvolist.size()<=0){
			throw new BusinessException("导出的数据为空");
		}
		List<SapplyModifyHVO> hvolist = new ArrayList();
		for (AggSapplyModifyHVO aggSapplyModifyHVO : aggvolist) {
			hvolist.add(aggSapplyModifyHVO.getParentVO());
		}
		ExportImpl(hvolist);
	}
	
	
	public JFileChooser getChooser() {
		if (m_chooser == null) {