Arcengine将excel表格中的坐标数据转化为点要素类

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using ESRI.ArcGIS.esriSystem;

using ESRI.ArcGIS.Carto;

using ESRI.ArcGIS.Controls;

using ESRI.ArcGIS.SystemUI;

using ESRI.ArcGIS.Geometry;

using ESRI.ArcGIS.Geodatabase;

using ESRI.ArcGIS.DataSourcesFile;

using ESRI.ArcGIS.DataSourcesOleDB;

namespace Moso_Bamboo_Forest_Visualization

{

class LoadExcel

{

private IFeatureClass createfeatureclass()

{

string tempStorePath =

System.Environment.CurrentDirectory;

IWorkspaceFactory workspacefactory = new ShapefileWorkspaceFactoryClass();

IFeatureWorkspace featureworkspace = (IFeatureWorkspace)workspacefactory.OpenFromFile(tempStorePath, 0);

string layerName = "points";

IFields pFields = new FieldsClass();

IFieldsEdit pFieldsEdit = pFields as IFieldsEdit;

/

IField shapeField = new FieldClass();

IFieldEdit shapeEdit = shapeField as IFieldEdit;

https://www.360docs.net/doc/0a16317274.html,_2 = "Shape";

shapeEdit.Type_2 = esriFieldType.esriFieldTypeGeometry;

IGeometryDef pGeometryDef = new GeometryDefClass();

IGeometryDefEdit pGeometryDefEdit = pGeometryDef as IGeometryDefEdit;

pGeometryDefEdit.GeometryType_2 =

esriGeometryType.esriGeometryPoint;

ISpatialReferenceFactory srFactory = new SpatialReferenceEnvironmentClass();

ISpatialReference sr1;

IProjectedCoordinateSystem pcs =

srFactory.CreateProjectedCoordinateSystem(102100);

sr1 = pcs;

pGeometryDefEdit.SpatialReference_2 = sr1;

shapeEdit.GeometryDef_2 = pGeometryDefEdit;

pFieldsEdit.AddField(shapeField);

IField x = new FieldClass();

IFieldEdit xx = x as IFieldEdit;

https://www.360docs.net/doc/0a16317274.html,_2 = "X";

xx.Type_2 = esriFieldType.esriFieldTypeDouble;

pFieldsEdit.AddField(x);

IField y = new FieldClass();

IFieldEdit yy = y as IFieldEdit;

https://www.360docs.net/doc/0a16317274.html,_2 = "Y";

yy.Type_2 = esriFieldType.esriFieldTypeDouble;

pFieldsEdit.AddField(y);

esriFeatureType pfeaturetype =

esriFeatureType.esriFTSimple;

IFeatureClass tempFeatureClass;

tempFeatureClass =

featureworkspace.CreateFeatureClass(layerName, pFields, null, null, pfeaturetype, "Shape", "text");

return tempFeatureClass;

}

public ILayer myGetExcelTable(string path)

{

ESRI.ArcGIS.esriSystem.IPropertySet proset = new ESRI.ArcGIS.esriSystem.PropertySetClass();

string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + @";Extended Properties=Excel 8.0";

proset.SetProperty("CONNECTSTRING", strcon);

IWorkspaceFactory workspf = new

ESRI.ArcGIS.DataSourcesOleDB.OLEDBWorkspaceFactoryClass();

IFeatureWorkspace fworkfac = workspf.Open(proset, 0) as IFeatureWorkspace;

IQueryDef myQueryDef = fworkfac.CreateQueryDef();

myQueryDef.Tables = "[Sheet1$]";

myQueryDef.SubFields = "*";

myQueryDef.WhereClause = "";

ICursor myCursor = myQueryDef.Evaluate();

IRow myRow;

IPoint point = new PointClass();

ILayer newlayer;

IFeatureClass newfeatureclass = createfeatureclass();

ISpatialReferenceFactory srFactory = new SpatialReferenceEnvironmentClass();

ISpatialReference sr1;

IProjectedCoordinateSystem pcs =

srFactory.CreateProjectedCoordinateSystem(102100);

sr1 = pcs;

while ((myRow = myCursor.NextRow()) != null)

{

point.PutCoords(double.Parse(myRow.get_Value(0).ToString()), double.Parse(myRow.get_Value(1).ToString()));

point.SpatialReference = sr1;

IFeatureCursor m_cursor = newfeatureclass.Insert(true);

IFeatureBuffer m_buffer =

newfeatureclass.CreateFeatureBuffer();

m_buffer.Shape = point;

m_buffer.set_Value(newfeatureclass.FindField("X"), double.Parse(myRow.get_Value(0).ToString()));

m_buffer.set_Value(newfeatureclass.FindField("Y"), double.Parse(myRow.get_Value(1).ToString()));

m_cursor.InsertFeature(m_buffer);

m_cursor.Flush();

}

IFeatureLayer newfeaturelayer = new FeatureLayerClass();

newfeaturelayer.FeatureClass = newfeatureclass;

newlayer = newfeaturelayer as ILayer;

return newlayer;

}

}

}