用C#读写删除更新excel表格记录的方法.doc

教你用C#读写、删除、更新excel表格记录 如图所示，编一个程序，鼠标单击窗体视图区（右边）时，获取一对坐标（X,Y)，点击保存将点保存到excel表记录中。此外，还实现了删除、更新功能以及打开excel表功能。插入和更新比较简单，和操作一般的数据库一样，但是删除稍微有点复杂，不能用delete from [Sheet1$] where ID=x的方式删除，自己可以去试，主要是excel数据之间的关系不像关系数据库那么简单，oledb不提供这种方法。所以只能用专门操作excel表的（Microsoft.Office.Interop.Excel名字空间下，先添加引用)来实现删除某条记录的功能。 源代码： using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Reflection; using Excel = Microsoft.Office.Interop.Excel; namespace Leation { public partial class FrmMain : Form { //定义变量 private OleDbConnection connection = null; private OleDbCommand cmd = null; private OleDbDataAdapter dataAdapter = null; private DataSet dataSet = null; private string filePath = @G:\points.xls; private string connStr = provider=microsoft.jet.oledb.4.0;data source=G:\\points.xls;extended properties=Excel 8.0;HDR=yes;IMEX=2; private string selectStr = select * from [Sheet1$]; private string cmdStr = null; private string OID = null; //对象ID private string x = null; private string y = null; private Excel.Application excelApp = null; private Excel.Workbook book = null; private Excel.Worksheet sheet = null; private Excel.Range range = null; //构造函数 public FrmMain() { InitializeComponent(); } //鼠标移动事件 private void splitContainer1_Panel2_MouseMove(object sender, MouseEventArgs e) { this.lblxy.Text = x= + e.X.ToString() + y= + e.Y.ToString(); } //鼠标按下事件 private void splitContainer1_Panel2_MouseDown(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Left) { this.tbX.Text = e.X.ToString(); this.tbY.Text = e.Y.ToString();