java根据excel模版导出数据详解编程语言

package ibp.core.util; 
 
import java.io.File; 
import java.io.FileInputStream; 
import java.io.FileNotFoundException; 
import java.io.InputStream; 
import java.io.OutputStream; 
import java.net.URLEncoder; 
import java.util.Map; 
 
import javax.servlet.http.HttpServletResponse; 
 
import net.sf.jxls.transformer.XLSTransformer; 
 
import org.apache.commons.io.FileUtils; 
import org.apache.poi.ss.usermodel.Workbook; 
 
/** 
 * <p>Excel帮助类 
 */ 
public class ExcelExportUtils { 
 
    /** 
     * 获取一个wb，导出图片用 
     * @param templateFile 
     * @param beans 
     * @return 
     * @throws Exception 
     */ 
    public static Workbook getWorkbook(String templateFile, 
            Map<Object, Object> beans) throws Exception{ 
        XLSTransformer transformer = new XLSTransformer(); 
        Workbook wb = transformer.transformXLS(getAbsoluteIn(templateFile), beans); 
        return wb; 
    } 
    /*** 
     * 得到绝对文件路径流 
     * @param path: excel模板路径 
     * @return 
     */ 
    public static InputStream getAbsoluteIn(String path){ 
        File file = new File(path); 
        InputStream in = null; 
        try { 
            in = new FileInputStream(file); 
        } catch (FileNotFoundException e) { 
            // TODO Auto-generated catch block 
            e.printStackTrace(); 
        } 
        return in; 
    }  
}

public class testaction{ 
/** 
* 导出excel 
* @param t10_page_in_parm 
* @param request 
* @param response 
*/ 
@RequestMapping(value="downloadT10_report.do",method=RequestMethod.POST) 
public void export(HttpServletRequest request,HttpServletResponse response){ 
//获取excel信息 
List list = null;//TODO 
Map<Object, Object> beans = new HashMap<Object, Object>(); 
beans.put("list", list); 
beans.put("count", list.size()); 
try { 
Workbook wb = ExcelExportUtils.getWorkbook(excelTemplatePath, beans); 
String uplodapath = "D:/temp"; 
String downLoadFileName = "testexcel.xlsx"; 
//下载图片到excel 
            downloadImgToExcel(wb, uplodapath, downLoadFileName, response); 
}catch (Exception e) { 
// TODO Auto-generated catch block 
            e.printStackTrace(); 
} 
} 
/** 
* 下载图片到excel 
* @param wb 
* @param uplodapath 
* @param downLoadFileName 
* @param response 
*/ 
private void downloadImgToExcel(XSSFWorkbook wb,String uplodapath,String downLoadFileName,HttpServletResponse response){ 
//下载图片到excel 
//begin 
BufferedImage bufferImg = null; 
try { 
//创建作图sheet 
XSSFSheet sheet1 = null; 
if(wb.getSheet("echarts")==null){ 
sheet1 = wb.createSheet("echarts"); 
}else{ 
sheet1 = wb.getSheet("echarts"); 
} 
//循环读取图片插入到excel 
String filedir = uplodapath + "//" +"reporttpl//"+LoginManager.getUserName(); 
File file = new File(filedir); 
if(file.isDirectory()){ 
String[] files = file.list(); 
//画图的顶级管理器，一个sheet只能获取一个（一定要注意这点）   
XSSFDrawing patriarch = sheet1.createDrawingPatriarch(); 
int i = 0; 
int rowbegin = 1; 
int rowend = 18; 
for(String _file : files){ 
if("png".equals(_file.substring(_file.lastIndexOf(".")+1))){ 
ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream(); 
bufferImg = ImageIO.read(new File(filedir + "//" + _file)); 
ImageIO.write(bufferImg, "png", byteArrayOut); 
//anchor主要用于设置图片的属性 
XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 255, 255,(short) 1, rowbegin, (short) 11, rowend); 
//插入图片     
                        patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), XSSFWorkbook.PICTURE_TYPE_PNG)); 
i++; 
rowbegin = i*18+1; 
rowend = rowbegin + 18; 
} 
} 
} 
response.setContentType("application/vnd.ms-excel"); 
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(downLoadFileName, "GBK")); 
OutputStream out = response.getOutputStream(); 
// 写入excel文件      
wb.write(out); 
out.close(); 
wb.close(); 
} catch (IOException e) { 
// TODO Auto-generated catch block 
            e.printStackTrace(); 
}  
//end 
    } 
}