读取Excel文件
public class POIUtils {
public static SXSSFWorkbook downloadExcelTemplate(String templateName) {
SXSSFWorkbook wb = null;
InputStream resourceAsStream = POIUtils.class.getClassLoader().getResourceAsStream(templateName);
try {
XSSFWorkbook workbook = new XSSFWorkbook(resourceAsStream);
wb = new SXSSFWorkbook(workbook, 500);
wb.setCompressTempFiles(false);
} catch (IOException e) {
throw new RuntimeException(e.getMessage());
}
return wb;
}
}
SXSSFWorkbook sxssfWorkbook = POIUtils.downloadExcelTemplate("template/tv_line_template.xlsx");
读取本地建立的json文件
public class SourceType {
public static JSONObject getRelation(){
URL resource = SourceType.class.getClassLoader().getResource("sourceType.json");
if(null == resource){
throw new RuntimeException("sourceType.json not found");
}
String content = FileUtil.readString(resource, Charset.defaultCharset().toString());
return (JSONObject) JSONObject.parse(content);
}
}
JSONObject relation = SourceType.getRelation();
if (sourceType != null && sourceType != ""){
String[] strings = sourceType.split(",");
for (String ss : strings) {
String b = String.valueOf(relation.get(ss));
String[] split = b.split(",");
source.addAll(Arrays.asList(split));
}
}