//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);
//    }
//
//
//}