Winform[C#]操作Excel[数据分组应用].docxVIP

?Winform(C#)操作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.Threading;using Microsoft.Office.Interop;namespace HeXieRandomGroup{??? public partial class RandomGroup : Form??? {??????? private DataSetmyDataSet;??????? private DataTable GroupDt1, GroupDt2, GroupDt3, GroupDt4, GroupDt5;??????? private Thread thread;??????? private object m_objOpt = System.Reflection.Missing.Value;??????? public RandomGroup()??????? {??????????? RandomGroup.CheckForIllegalCrossThreadCalls = false;??????????? InitializeComponent();??????? }??????? private void ConectToxsl_Click(object sender, EventArgs e)??????? {??????????? GetConnect();??????????? this.Start.Enabled = true;??????? }??????? private void GetConnect()??????? {??????????? try??????????? {??????????????? string strCon = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Application.StartupPath.ToString() + @/hexie.xls; Extended Properties=Excel 8.0;HDR=No;IMEX=1;??????????????? OleDbConnectionmyConn = new OleDbConnection(strCon);??????????????? string strCom = SELECT * FROM [Sheet1$];??????????????? myConn.Open();??????????????? OleDbDataAdaptermyCommand = new OleDbDataAdapter(strCom, myConn);??????????????? myDataSet = new DataSet();??????????????? myCommand.Fill(myDataSet, [Sheet1$]);??????????????? myConn.Close();??????????????? MessageBox.Show(连接成功！);??????????????? this.ConectToxsl.Enabled = false;??????????????? dataGridView1.DataSource = myDataSet.Tables[0].DefaultView;??????????? }??????????? catch (OleDbException e)??????????? {??????????????? MessageBox.Show(请确认hexie.xls表存在！ + e.Message);??????????? }??????????? catch (Exception e)??????????? {??????????????? MessageBox.Show(链接失败 + e.Message);??????????? }??????? }??????? private void Start_Click(object sender, EventArgs e)??????? {??????????? if (myDataSet.Tables[0].Rows.Count 0)??????????? {?????????????