//package com.ruoyi.web.controller.tool;
|
//
|
//import cn.afterturn.easypoi.excel.ExcelExportUtil;
|
//import cn.afterturn.easypoi.excel.entity.ExportParams;
|
//import com.alibaba.excel.EasyExcel;
|
//import com.alibaba.excel.write.metadata.WriteSheet;
|
//import com.alibaba.excel.write.metadata.fill.FillConfig;
|
//import com.alibaba.excel.write.style.column.SimpleColumnWidthStyleStrategy;
|
//import com.ruoyi.common.utils.WebUtils;
|
//import com.ruoyi.system.export.MerchantImport;
|
//import org.apache.poi.ss.usermodel.*;
|
//import org.apache.poi.ss.util.CellRangeAddressList;
|
//import org.apache.poi.xssf.usermodel.*;
|
//
|
//import javax.servlet.ServletOutputStream;
|
//import javax.servlet.http.HttpServletResponse;
|
//import java.io.FileNotFoundException;
|
//import java.io.FileOutputStream;
|
//import java.net.URLEncoder;
|
//import java.util.ArrayList;
|
//import java.util.List;
|
//
|
//public class ExcelExportExample {
|
// public static void main(String[] args) throws Exception {
|
// List<MerchantImport> merchantImports = new ArrayList<>();
|
// Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), MerchantImport.class, merchantImports);
|
// // 生成1W条选项
|
// List<String> dataList = new ArrayList<>();
|
// dataList.add("武侯区");
|
// dataList.add("金牛区");
|
// dataList.add("双流区");
|
// dataList.add("青羊区");
|
// ExcelUtil.selectList(workbook, 1, 65535, 2, 2, dataList.toArray(new String[dataList.size()]), 1);
|
// ServletOutputStream outputStream = null;
|
// HttpServletResponse response = WebUtils.response();
|
// String fileName = URLEncoder.encode("商户信息导入模板.xls", "utf-8");
|
// response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
|
// response.setHeader("content-Type", "application/vnd.ms-excel");
|
// response.setHeader("Pragma", "no-cache");
|
// response.setHeader("Cache-Control", "no-cache");
|
// outputStream = response.getOutputStream();
|
// workbook.write(outputStream);
|
// }
|
//
|
//
|
//}
|
