JAVA-GDAL,将DXF转换成EXCEL格式

POM文件引入

<dependency>
    <groupId>org.gdal</groupId>
	<artifactId>gdal</artifactId>
	<version>3.5.0</version>
</dependency>

示例代码

ogr.RegisterAll();
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8", "YES");
gdal.SetConfigOption("SHAPE_ENCODING", "");
gdal.SetConfigOption("DXF_FEATURE_LIMIT_PER_BLOCK", "-1");
gdal.SetConfigOption("DXF_ENCODING", "ASCII"); //设置DXF缺省编码
gdal.SetConfigOption("OGR_XLS_FIELD_TYPES ", "STRING");
String strVectorFile = "文件路径";
DataSource ds = ogr.Open(strVectorFile, 0);
if (ds == null) {
	return AjaxJson.error("打开文件失败!");
}
System.out.println("打开文件成功!");
Driver dv = ogr.GetDriverByName("XLSX");
if (dv == null) {
	return AjaxJson.error("打开驱动失败!");
}
System.out.println("打开驱动成功!");
String uuid = IdUtil.simpleUUID();
String geojsonPath = absolutePath.replace(".dxf", "");
geojsonPath = geojsonPath + "" + uuid + ".xlsx";
DataSource ods = dv.CreateDataSource(geojsonPath);
Layer oLayer = ds.GetLayerByIndex(0);
System.out.println(oLayer.GetFeatureCount());
Feature feature;
Map<String, String> points = new HashMap<>();

while ((feature = oLayer.GetNextFeature()) != null) {
	//获取空间属性
	Geometry geometry = feature.GetGeometryRef();

	if (StringUtils.isNotBlank(layer) && !layerNames.contains(feature.GetFieldAsString("Layer"))) {
		continue;
	}

	if (geometry.GetPoints() != null) {
		if ("POINT".equals(geometry.GetGeometryName())) {
			feature.SetField(3, JSON.toJSON(geometry.GetPoints()).toString());
			points.put((feature.GetFID() + 1) + "", JSON.toJSON(geometry.GetPoints()).toString());
		}
	}
}
Layer excelLayer = ods.CopyLayer(ds.GetLayerByIndex(0), "LAYER");
while ((feature = excelLayer.GetNextFeature()) != null) {
	if (StringUtils.isNotBlank(layer) && !layerNames.contains(feature.GetFieldAsString("Layer"))) {
		excelLayer.DeleteFeature(feature.GetFID());
		continue;
	}

	String point = points.get(feature.GetFID() + "");
	if (StringUtils.isNotBlank(point)) {
		System.out.println(feature.GetFID());
		feature.SetField(3, point);
	}
	excelLayer.SetFeature(feature);
}
System.out.println("转换成功!");
ds.FlushCache();
ds.delete();
ods.FlushCache();
ods.delete();
dv.delete();

  • 7
    点赞
  • 11
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值