今天的开发中遇到的一个问题：
我在resources目录下的templates下建了一个xml文件。
在config类中想读取这个文件， 我使用了如下的代码：
File file = ResourceUtils.getFile("classpath:templates/importEXCEL.xml");
这种代码在windows下是没有问题的，但是一旦打包到了linux环境下，linux系统在jar包路径上多加了！符号，导致程序按这种路径找文件找不到。
改成下面这种写法就可以了：
ClassPathResource classPathResource = new ClassPathResource("templates/importEXCEL.xml");
附上xml文件和代码：
import com.techen.tap.exception.BusinessException;
import com.techen.tap.utils.I18nUtil;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.dom4j.Attribute;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.ClassPathResource;
import org.springframework.stereotype.Component;
import org.springframework.util.ResourceUtils;
import org.springframework.web.multipart.MultipartFile;
import java.io.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* @param paraMap
* @Modify: EXCEL导入模板操作类
* @author: lihao
* @date: 2021/5/12 17:33
* @return ResponseResult<Object>
*/
@Configuration
@Component
public class EXCELConfig {
// @Value("${excel.xmlPath}")
// static String xmlPath;
final static String EXAMPLE = "example";
final static String DEFAULT = "default";
Document document;
public EXCELConfig() throws FileNotFoundException, DocumentException {
ClassPathResource classPathResource = new ClassPathResource("templates/importEXCEL.xml");
// File file = ResourceUtils.getFile("classpath:templates/importEXCEL.xml");
// File file = ResourceUtils.getFile(xmlPath);
// InputStream in = new FileInputStream(file);
InputStream in = null;
try {
in = classPathResource.getInputStream();
} catch (IOException e) {
e.printStackTrace();
}
SAXReader reader = new SAXReader();
document = reader.read(in);
}
/**
* @param paraMap
* @return ResponseResult<Object>
* @Modify: 获取模板配置中的所有模板名称
* @author: lihao
* @date: 2021/5/15 13:55
*/
public StringBuffer getAllExcelModelName() {
StringBuffer result = new StringBuffer();
// 获取xml文档根节点
Element root = document.getRootElement();
List<Element> listElement = root.elements();
for (int i = 0; i < listElement.size(); i++) {
String elementName = listElement.get(i).getName();
result.append(elementName);
}
return result;
}
/**
* @param paraMap
* @return ResponseResult<Object>
* @Modify: 按模版名称获取模版的excel文件
* @author: lihao
* @date: 2021/5/15 14:12
*/
public byte[] getExcelModelByName(String modelName) throws IOException {
// 获取xml文档根节点
Element root = document.getRootElement();
Element element = root.element(modelName);
if (element == null) {
return null;
}
//构造excel文件
HSSFWorkbook excel = new HSSFWorkbook();
HSSFSheet sheet0 = excel.createSheet(element.getName());
HSSFRow rowNameExcel = sheet0.createRow(0);
HSSFRow rowDataExcel = sheet0.createRow(1);
List<Element> colList = element.elements();
for (int i = 0; i < colList.size(); i++) {
String data = colList.get(i).getData().toString();
// 标头
HSSFCell cellExcel = rowNameExcel.createCell(i);
cellExcel.setCellValue(data);
// 示例内容
HSSFCell cellExample = rowDataExcel.createCell(i);
Attribute attribute = colList.get(i).attribute(EXAMPLE);
if (attribute != null) {
cellExample.setCellValue(attribute.getValue());
}
}
ByteArrayOutputStream bos = new ByteArrayOutputStream();
excel.write(bos);
byte[] brray = bos.toByteArray();
return brray;
}
/**
* @param paraMap
* @return ResponseResult<Object>
* @Modify: excel转换为map
* 将要导入的excel表格信息转换为map格式
* @author: lihao
* @date: 2021/5/22 11:47
*/
public List<Map> exacleToMap(MultipartFile file, String modelName) {
HSSFWorkbook excel = null;
HSSFSheet sheet = null;
HSSFRow row = null;
List<Map> resultMap = new ArrayList<>();
//构造excel文件
try {
excel = new HSSFWorkbook(new POIFSFileSystem(file.getInputStream()));
} catch (IOException e) {
throw new BusinessException(I18nUtil.getMessageDefault("file.InvalidFormat", "文件格式错误，请重试"));
}
// 获取指定名称的节点
Element root = document.getRootElement();
Element elementModel = root.element(modelName);
List<Element> elements = elementModel.elements();
if (excel != null) {
for (int i = 0; i < excel.getNumberOfSheets(); i++) {
sheet = excel.getSheetAt(i);
// 从索引为1的行开始获取
for (int r = 1; r < sheet.getPhysicalNumberOfRows(); r++) {
row = sheet.getRow(r);
for (int c = 0; c < row.getPhysicalNumberOfCells(); c++) {
Map map = new HashMap();
String key = elements.get(c).getName();
map.put(key, row.getCell(c));
resultMap.add(map);
}
}
}
}
System.out.print(resultMap.toString());
return resultMap;
}
}
xml文件代码：
<root>
<ConsAccount>
<cons_name default="1" example="张三">用户名称</cons_name>
<cons_addr default="1" example="省市区">用户地址</cons_addr>
<identity_card default="1" example="XXX">身份证号</identity_card>
<cons_tel default="1" example="XXX">电话号码</cons_tel>
<contact_name default="1" example="张三">联系人</contact_name>
<postal_code default="1" example="05321">邮政编码</postal_code>
<cons_email default="1" example="xxx@qq.com">电子邮件</cons_email>
<inuse_num default="1" example="3">使用人口</inuse_num>
<living_area default="1" example="108">居住面积</living_area>
<msg_mobile default="1" example="XXX">短信提醒号码</msg_mobile>
</ConsAccount>
<Meter>
<install_addr default="1" example="xxx">安装地址</install_addr>
<comm_module_addr default="1" example="xxx">模块地址</comm_module_addr>
<asset_no default="1" example="xxx">资产号</asset_no>
<run_status_code default="01" example="xxx">运行状态</run_status_code>
<flag_total default="0" example="xxx">总分类型</flag_total>
<flag_download default="1" example="xxx">档案上云状态</flag_download>
<R_val default="1" example="78">R值</R_val>
<thermal_adapt default="1" example="34℃~67℃">温度自适应性</thermal_adapt>
</Meter>
</root>
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
