using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OleDb;
using?ESRI.ArcGIS.Carto;
using?ESRI.ArcGIS.GlobeCore;
using?ESRI.ArcGIS.Geodatabase;
using?ESRI.ArcGIS.DataSourcesFile;
using?ESRI.ArcGIS.GeocodingTools;
using?ESRI.ArcGIS.Geometry;
using?ESRI.ArcGIS.esriSystem;
using?ESRI.ArcGIS.GeoDatabaseExtensions;
using?ESRI.ArcGIS.DataSourcesGDB;


namespace?ArcEngine
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????ESRI.ArcGIS.RuntimeManager.Bind（ESRI.ArcGIS.ProductCode.EngineOrDesktop）;
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{

????????}

????????private?DataSet?importExcelToDataSet（string?FilePath）
????????{

????????????string?strConn;

????????????strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;“?+?“Data?Source=“?+?FilePath?+?“;Extended?Properties=Excel?8.0;“;

????????????OleDbConnection?conn?=?new?OleDbConnection（strConn）;

????????????OleDbDataAdapter?myCommand?=?new?OleDbDataAdapter（“SELECT?*?FROM?[Sheet1$]“?strConn）;

????????????DataSet?myDataSet?=?new?DataSet（）;

????????????try
????????????{

????????????????myCommand.Fill（myDataSet）;

????????????}

????????????catch?（Exception?ex）
????????????{

???????????????

????????????}

????????????return?myDataSet;

????????}
????????private?void?ProcessDataSet（DataSet?dataSet）
????????{
????????????
????????}

????????private?void?打開ToolStripMenuItem_Click（object?sender?EventArgs?e）
????????{

????????????OpenFileDialog?openFileDialog=new?OpenFileDialog（）;
????????????openFileDialog.InitialDirectory=“D:\\“;//注意這里寫路徑時要用c:\\而不是c:\
????????????openFileDialog.Filter=“excl文件|*.xls|所有文件|*.*“;
????????????openFileDialog.RestoreDirectory=true;
????????????openFileDialog.FilterIndex=1;
????????????if?（openFileDialog.ShowDialog（）==DialogResult.OK）
????????????{
????????????????string?fName=openFileDialog.FileName;
????????????????DataTable?myT?=?ExcelToDataTable（fName?“sheet1“）;
????????????????String?mystr?=?myT.Rows[0][0].ToString（）;

????????????????int?count?=?0;
????????????????ilayer?ly?=?CreateShapeFile（fName）;

????????????????if?（ly?==?null）
????????????????????return;
????????????????for?（int?i?=?1;?i?????????????????{
????????????????????//string?temp?=?myT.Rows[i][“ID“].ToString（）;
????????????????????string?name?=?myT.Rows[i][1].ToString（）;
????????????????????string?address?=?myT.Rows[i][2].ToString（）;
????????????????????double?jingdu?=?Convert.ToDouble（myT.Rows[i][3]）;

????????????????????double?weidu?=?Convert.ToDouble（myT.Rows[i][4]）;

????????????????????if?（addPoint（ly?jingdu?weidu?name?address））
????????????????????{
????????????????????????count++;
????????????????????}

???????????????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-09-26?23:05??excel生成點圖層\
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\
?????文件???????23721??2014-03-16?17:02??excel生成點圖層\ArcEngine\ArcEngine\ArcEngine.csproj
?????文件????????9018??2014-03-16?18:08??excel生成點圖層\ArcEngine\ArcEngine\Form1.Designer.cs
?????文件???????10514??2014-03-16?18:08??excel生成點圖層\ArcEngine\ArcEngine\Form1.cs
?????文件???????11925??2014-03-16?18:08??excel生成點圖層\ArcEngine\ArcEngine\Form1.resx
?????文件?????????490??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\Program.cs
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\Properties\
?????文件????????1368??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\Properties\AssemblyInfo.cs
?????文件????????2868??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\Properties\Resources.Designer.cs
?????文件????????5612??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\Properties\Resources.resx
?????文件????????1094??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\Properties\Settings.Designer.cs
?????文件?????????249??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\Properties\Settings.settings
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\bin\
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\bin\Debug\
?????文件???????22528??2014-03-16?18:09??excel生成點圖層\ArcEngine\ArcEngine\bin\Debug\ArcEngine.exe
?????文件???????32256??2014-03-16?18:09??excel生成點圖層\ArcEngine\ArcEngine\bin\Debug\ArcEngine.pdb
?????文件???????11600??2014-03-16?18:22??excel生成點圖層\ArcEngine\ArcEngine\bin\Debug\ArcEngine.vshost.exe
?????文件?????????490??2010-03-17?22:39??excel生成點圖層\ArcEngine\ArcEngine\bin\Debug\ArcEngine.vshost.exe.manifest
?????文件??????765440??2010-05-19?14:25??excel生成點圖層\ArcEngine\ArcEngine\bin\Debug\ESRI.ArcGIS.Desktop.AddIns.dll
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\obj\
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\
?????目錄???????????0??2014-03-16?18:23??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\
?????文件????????4112??2014-03-16?18:09??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\ArcEngine.Form1.resources
?????文件?????????180??2014-03-16?17:02??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\ArcEngine.Properties.Resources.resources
?????文件????????1122??2014-03-16?18:22??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\ArcEngine.csproj.FileListAbsolute.txt
?????文件???????22528??2014-03-16?18:09??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\ArcEngine.exe
?????文件???????32256??2014-03-16?18:09??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\ArcEngine.pdb
?????文件????????2164??2014-03-16?14:51??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????15632??2014-03-16?18:09??excel生成點圖層\ArcEngine\ArcEngine\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
............此處省略6個文件信息