利用公司所学作为简单示例:
(简单实现逻辑为将文件生成在项目中,当用户下载后将文件重新删除)
以下程序为Java中Excel的属性配置,参数配置,数据配置等
public IResData exportGzrwqkaxmtjData(final IReqData req) throws SwordBaseCheckedException, IOException {
final IResData res = new SwordRes();
//获取窗体的值,引入实体类
final Map<String, String> gzrwqkaxmtjForm = req.getFormData("gzrwqkaxmtjForm");
//获取所需要导入Excel表中的数据
final List<Map<String, Object>> information = (List<Map<String, Object>>) SwordServiceUtils.callService("DSJYPT.XMGL.GZRW.QKAXMTJ", gzrwqkaxmtjForm);
//定义Excel中表格的数据格式
final List<Map<String, Object>> excelList = new ArrayList<Map<String, Object>>();
//定义Excel的相关信息
final Map<String, Object> excel = new HashMap<String, Object>();
excel.put("title", "标题名称");