| | |
|---|
| | | |
|---|
| | | |
|---|
| | | private String saveExcel(MultipartFile file) { |
|---|
| | | String fileSaveDir2 = Global.getProfile() + "\\template\\" ; |
|---|
| | | |
|---|
| | | String filename = file.getOriginalFilename(); |
|---|
| | | File dir = new File(fileSaveDir); |
|---|
| | | File dir = new File(fileSaveDir2); |
|---|
| | | if (!dir.exists()) { |
|---|
| | | dir.mkdir(); |
|---|
| | | } |
|---|
| | | String addr = fileSaveDir + filename; |
|---|
| | | String addr = fileSaveDir2 + filename; |
|---|
| | | try { |
|---|
| | | File dest = new File(addr); |
|---|
| | | file.transferTo(dest); |
|---|
| | |
|---|
| | | private List<Hole> readData(String filepath) { |
|---|
| | | ExcelReader reader = ExcelUtil.getReader(filepath, 0); |
|---|
| | | reader.addHeaderAlias("钻孔编号", "code"); |
|---|
| | | reader.addHeaderAlias("钻孔类型", "type"); |
|---|
| | | reader.addHeaderAlias("孔口高程(m)", "elevation"); |
|---|
| | | reader.addHeaderAlias("设计孔深(m)", "depth"); |
|---|
| | | reader.addHeaderAlias("钻孔状态", "status"); |
|---|
| | | reader.addHeaderAlias("钻孔经度", "longitude"); |
|---|
| | | reader.addHeaderAlias("钻孔纬度", "latitude"); |
|---|
| | | reader.addHeaderAlias("总进尺(m)", "footage"); |
|---|
