目录
工具类 toExcel.java 和main excel导出操作
前言:上一篇用了easypoi的excel通用导出方法,但是boss不同意,白白弄了,要改成apache.poi,因为同事之前已经用了这个jar包,只好重写了。
-
准备
-
JAR
<!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.47</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.json/json -->
<dependency>
<groupId>org.json</groupId>
<artifactId>json</artifactId>
<version>20160810</version>
</dependency>
-
读取resource x.json文件
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.google.common.base.Charsets;
import com.google.common.io.Resources;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.IOException;
import java.net.URL;
import java.util.Enumeration;
import java.util.LinkedHashMap;
import java.util.Map;
/**
* 属性文件获取工具类(仅json)
*
* @author WangZhenkun on 18-8-1
*/
public class PropertiesUtils {
private static final Logger LOGGER = LoggerFactory.getLogger(PropertiesUtils.class);
/*
* 根据json文件名称获取json配置文件数据
*
* @param fileName json文件名称前缀,如果在resource下直接写文件名,如果有路径,请在前面添加路径如:"com/xxx/abc"
*/
public static JSONObject getJsonResource(String fileName) {
fileName += ".json";
ClassLoader classLoader = getClassLoader();
Enumeration<URL> resources;
JSONObject jsonObject = new JSONObject();
try {
resources = classLoader.getResources(fileName);
} catch (IOException e) {