导出功能接口:
public class exportList {
private final static Logger logger = LoggerFactory.getLogger(exportList.class);
/**
* 导出资金统计列表
* @param sumList
* @param fundRecordsList
*/
public static void fundRecordsExport(List<ProFundRecords> sumList, List<ProFundRecords> fundRecordsList, HttpServletResponse response){
OutputStream os = null;
try {
//读取的模板文件的位置(在resources下的resources文件夹里面)
String srcPath = GetResource.class.getClassLoader().getResource("/resources/资金流动统计.xls").getPath();
POIFSFileSystem fs =new POIFSFileSystem(new FileInputStream(srcPath));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheet("资金流动统计");
//插入总支出和总到账
fo