java 中Excel转shape file的实例详解

java 中Excel转shape file的实例详解

java  中Excel转shape file的实例详解

概述：

本文讲述如何结合geotools和POI实现Excel到shp的转换，再结合前文shp到geojson数据的转换，即可实现用户上传excel数据并在web端的展示功能。

截图：

原始Excel文件

运行耗时

运行结果

代码：

package com.lzugis.geotools;

import http://com.lzugis.CommonMethod;

import com.vividsolutions.jts.geom.Coordinate;

import com.vividsolutions.jts.geom.GeometryFactory;

import com.vividsolutions.jts.geom.Point;

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.geotools.data.FeatureWriter;

import org.geotools.data.Transaction;

import org.geotools.data.shapefile.ShapefileDataStore;

import org.geotools.data.shapefile.ShapefileDataStoreFactory;

import org.geotools.feature.simple.SimpleFeatureTypeBuilder;

import org.geotools.referencing.crs.DefaultGeographicCRS;

import org.opengis.feature.simple.SimpleFeature;

import org.opengis.feature.simple.SimpleFeatureType;

import java.io.File;

import java.io.FileInputStream;

import java.io.InputStream;

import java.io.Serializable;

import java.nio.charset.Charset;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

/**

* Created by admin on 2017/9/6.

*/

public class Xls2Shape {

static Xls2Shape xls2Shp = new Xls2Shape();

private static String rootPath = System.getProperty("user.dir");

private CommonMethod cm = new CommonMethod();

private HSSFSheet sheet;

private Class getCellType(HSSFCell cell) {

if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {

return String.class;

} else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {

return Double.class;

} else {

return String.class;

}

}

private Object getCellValue(HSSFCell cell) {

if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {

return cell.getRichStringCellValue().getString();

} else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {

return cell.getNumericCellValue();

} else {

return "";

}

}

private List

List

HSSFRow header = sheet.getRow(0);

HSSFRow value = sheet.getRow(1);

//获取总列数

int colNum = header.getPhysicalNumberOfCells();

for (int i = 0; i < colNum; i++) {

HSSFCell cellField = header.getCell(i);

HSSFCell cellvalue = value.getCell(i);

String fieldName = cellField.getRichStringCellValue().getString();

fieldName = cm.getPinYinHeadChar(fieldName);

Class fieldType = getCellTypefzQpJwMH(cellvalue);

Map map = new HashMap();

map.put("name", fieldName);

map.put("type", fieldType);

list.add(map);

}

return list;

}

public void excel2Shape(String xlsfile, String shppath) {

POIFSFileSystem fs;

HSSFWorkbook wb;

HSSFRow row;

try {

InputStream is = new FileInputStream(xlsfile);

fs = new POIFSFileSystem(is);

wb = new HSSFWorkbook(fs);

sheet = wb.getSheetAt(0);

//获取总列数

int colNum = sheet.getRow(0).getPhysicalNumberOfCells();

// 得到总行数

int rowNum = sheet.getLastRowNum();

List list = getExcelHeader();

//创建shape文件对象

File file = new File(shppath);

Map params = new HashMap();

params.put(ShapefileDataStoreFactory.URLP.key, file.toURI().toURL());

ShapefileDataStore ds = (ShapefileDataStore) new ShapefileDataStoreFactory().createNewDataStore(params);

//定义图形信息和属性信息

SimpleFeatureTypeBuilder tb = new SimpleFeatureTypeBuilder();

tb.setCRS(DefaultGeographicCRS.WGS84);

tb.setName("shapefile");

tb.add("the_geom", Point.class);

for (int i = 0; i < list.size(); i++) {

http://Map map = (Map) list.get(i);

tb.add(map.get("name").toString(), (Class) map.get("type"));

}

ds.createSchema(tb.buildFeatureType());

//设置编码

Charset charset = Charset.forName("GBK");

ds.setCharset(charset);

//设置Writer

FeatureWriter writer = ds.getFeatureWriter(ds.getTypeNames()[0], Transaction.AUTO_COMMIT);

//写下一条

SimpleFeature feature = null;

for (int i = 1; i < rowNum; i++) {

row = sheet.getRow(i);

feature = writer.next();

Map mapLonLat = new HashMap();

for (int j = 0; j < colNum; j++) {

HSSFCell cell = row.getCell(j);

Map mapFields = (Map) list.get(j);

String fieldName = mapFields.get("name").toString();

feature.setAttribute(fieldName, getCellValue(cell));

if (fieldName.toLowerCase().equals("lon") || fieldName.toLowerCase().equals("lat")) {

mapLonLat.put(fieldName, getCellValue(cell));

}

}

feature.setAttribute("the_geom", new GeometryFactory().createPoint(new Coordinate((double) mapLonLat.get("lon"), (double) mapLonLat.get("lat"))));

}

writer.write();

writer.close();

ds.dispose();

} catch (Exception e) {

e.printStackTrace();

}

}

public static void main(String[] args) {

long start = System.currentTimeMillis();

String xlspath = rootPath + "/data/xls/capital.xls",

shppath = rootPath + "/out/capital.shp";

xls2Shp.excel2Shape(xlspath, shppath);

System.out.println("共耗时" + (System.currentTimeMillis() - start) + "ms");

}

}

说明：

1、转换仅限点对象的转换；

2、保留所有excel相关的属性，lon、lat字段是必须要有的；

3、对于中文字段，做了取首字母的处理；

如有疑问请留言或者到本站社区交流讨论，感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。