vue导出（下载）Excel模板

vue导出（下载）Excel模板

代码

导出按钮 代码片.

// 导出按钮
<el-button type="primary" size="small" @click="this.downloadMemberTemplate">模板下载</el-button>

js 代码片.

 async downloadMemberTemplate(){
  try {
     window.location.href="/api/ics/project/downloadMemberTemplate";
   } catch (ex) {
     this.$message.error(`下载失败：${ex}`)
   }
 },

java代码片.

   // 下载导入隐患分类模版
    @RequestMapping(value = "/downloadMemberTemplate", method = RequestMethod.GET, produces = "application/json;charset=UTF-8")
    public void downloadHiddenTroubleClassifyMaintainTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {

        String realPathDir = ClassUtils.getDefaultClassLoader().getResource("").getPath()+TMP_PATH;
        String os = System.getProperty("os.name");
        if (os.toLowerCase().startsWith("win")) {  //如果是Windows系统
            realPathDir=java.net.URLDecoder.decode(realPathDir.substring(1,realPathDir.length()), "UTF-8");
        }
        System.out.println(realPathDir);
        realPathDir = CleanPathUtil.cleanString(realPathDir);
        File outputFile = new File(realPathDir + "/members_template.xlsx");
        DownLoadUtils.download(outputFile, "人员范围导入模版.xlsx", request, response);
    }

工具类 CleanPathUtil 代码片.

   package net.ourway.common.utils;

import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class CleanPathUtil {
	public static String cleanString(String aString) {
		return aString;
/*		if (aString == null) return null;
	    String cleanString = "";
		try {
		    for (int i = 0; i < aString.length(); ++i) {
		        cleanString += cleanChar(aString.charAt(i));
		    }
		    cleanString=FileSwitch.vaildFilePath(cleanString);
		    cleanString=CleanHeadUtil.cleanHead(cleanString);
			cleanString=replaceString(cleanString);
			cleanString=validFilePath(cleanString);
		} catch (Exception e) {
			e.printStackTrace();
		}
	    return cleanString;*/
	}
	
	public static boolean patternCheck(String str){
		if(!Pattern.matches("[0-9A-Za-z@.]+", str)){
			return false;
		}
		return true;
	}
	private static String replaceString(String filePath) throws Exception {
		String fileNameInformation = new String(filePath.getBytes("UTF-8"), "ISO-8859-1");
		String fileRegex = "^(?<path>(?:[a-zA-Z]:)?\\\\(?:[^\\\\\\?\\/\\*\\|<>:\"]+\\\\)+)(?<filename>(?<name>[^\\\\\\?\\/\\*\\|<>:\"]+?)\\.(?<ext>[^.\\\\\\?\\/\\*\\|<>:\"]+))$";
		Pattern pa = Pattern.compile(fileRegex);
		Matcher ma = pa.matcher(fileNameInformation);
		if (ma.find()) {
			filePath=ma.replaceAll("");
		}
		return filePath;
	}
	
	
	public static String validFilePath(String filepath) throws Exception{
		List<String> allowedExtensions = new ArrayList<>();
		boolean result = false;
		allowedExtensions.add(".xml");
		allowedExtensions.add(".jar");
		allowedExtensions.add(".api");
		allowedExtensions.add(".properties");
		allowedExtensions.add(".xsd");
		allowedExtensions.add(".flw");
		allowedExtensions.add(".schema");
		allowedExtensions.add(".MF");
		allowedExtensions.add(".log");
		allowedExtensions.add(".xls");
		allowedExtensions.add(".xlsx");
		for(String suf:allowedExtensions){
			if(filepath.endsWith(suf)){
				result = true;
				break;
			}
		}
		if(!result){
			   // 按指定模式在字符串查找
		      String pattern1 = "(.*)(\\.log\\.{0,1}\\d{0,})$";
		      // 创建 Pattern 对象
		      Pattern r1 = Pattern.compile(pattern1);
		      // 现在创建 matcher 对象
		      Matcher m1 = r1.matcher(filepath);
			  if(!m1.matches()){
					Exception Exception = new Exception("file name is Illage") ;
					throw Exception   ;
			  }
		}
		filepath.replaceAll("../", "");
		filepath.replaceAll("..\\\\", "");
	return filepath;
	
}
	
    public static boolean isChinese(char c) {
        Character.UnicodeBlock ub = Character.UnicodeBlock.of(c);
        if (ub == Character.UnicodeBlock.CJK_UNIFIED_IDEOGRAPHS
                || ub == Character.UnicodeBlock.CJK_COMPATIBILITY_IDEOGRAPHS
                || ub == Character.UnicodeBlock.CJK_UNIFIED_IDEOGRAPHS_EXTENSION_A
                || ub == Character.UnicodeBlock.GENERAL_PUNCTUATION
                || ub == Character.UnicodeBlock.CJK_SYMBOLS_AND_PUNCTUATION
                || ub == Character.UnicodeBlock.HALFWIDTH_AND_FULLWIDTH_FORMS) {
            return true;
        }
        return false;
    }

	private static char cleanChar(char aChar) {

	    // 0 - 9
	    for (int i = 48; i < 58; ++i) {
	        if (aChar == i) return (char) i;
	    }

	    // 'A' - 'Z'
	    for (int i = 65; i < 91; ++i) {
	        if (aChar == i) return (char) i;
	    }

	    // 'a' - 'z'
	    for (int i = 97; i < 123; ++i) {
	        if (aChar == i) return (char) i;
	    }
	    
	    if (isChinese(aChar))
	    	return aChar;

	    switch (aChar) {
	        case '/':
	            return '/';
	        case '.':
	            return '.';
	        case '-':
	            return '-';
	        case '_':
	            return '_';
	        case ' ':
	            return ' ';
	    }
	    return '%';
	}
}