这里入坑,用的是以前别人用过的项目框架,excel导出用到的jar版本太多出现冲突,分别有3.8,3.13,3.15,3.17版本,折腾了一天
实际上需要用到的jar有,最后采用的是1.5版本竟然可以了,最新的类最全,不过还是找最合适的
<dependency>
<groupId>org.jxls</groupId>
<artifactId>jxls-poi</artifactId>
<version>1.0.15</version>
</dependency>
前台代码:
$('#getCustomerInfo').on('click', function () {
var checkStatus = table.checkStatus('searchReloadCustomer');
if (checkStatus.data.length === 0) {
layer.msg('请最少选择一条数据');
return;
}
var ids = [];
for (var i = 0; i < checkStatus.data.length; i++) {
ids.push(checkStatus.data[i].id);
}
common.ajaxDownloader({
url: url_customer + "api/customer/getCustomerInfoByExcel?token=" + getToken(),
data: {ids: ids.join(",")}
});
});
后台controller
service实现的代码——获取数据
public Map<String, Object> findCustomerInfoTemplateModel(String[] ids) {
Map<String, Object> model = new HashMap<>(16);
List<CustomerVoTemplateModel> templateVoList = new ArrayList<>();
CustomerVoTemplateModel customerVoTemplateModel = new CustomerVoTemplateModel();
for (String id : ids) {
CustomerVo customerVo = customerMapper.getCustomerVoById(id);
customerVoTemplateModel.setId(id);
//用户名
customerVoTemplateModel.setUsername(customerVo.getUsername());
//用户编码
customerVoTemplateModel.setCustomerCode(customerVo.getCustomerCode());
//姓名