将文本文件数据分解到Excel中的不同数据表

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.IO;
using System.Text.Regularexpressions;

namespace TxtToMulSheets
{
    public partial class Frm_Main : Form
    {
        public Frm_Main（）
        {
            InitializeComponent（）;
        }

        private void btn_SelectTxt_Click（object sender EventArgs e）
        {
            OpenFileDialog openTxt = new OpenFileDialog（）;//实例化打开对话框对象
            openTxt.Filter = “文本文件|*.txt“;//设置打开文件筛选器
            openTxt.Multiselect = false;//设置打开对话框中不能多选
            if （openTxt.ShowDialog（） == DialogResult.OK）//判断是否选择了文件
            {
                txt_Txt.Text = openTxt.FileName;//显示选择的文本文件
            }
        }

        private void btn_SelectExcel_Click（object sender EventArgs e）
        {
            OpenFileDialog openExcel = new OpenFileDialog（）;//实例

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件         932  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets.sln
     文件       20480  2010-11-03 16:27  TxtToMulSheets\TxtToMulSheets.suo
     文件        3867  2010-06-08 13:32  TxtToMulSheets\TxtToMulSheets\Frm_Main.cs
     文件        7768  2010-06-08 13:12  TxtToMulSheets\TxtToMulSheets\Frm_Main.designer.cs
     文件        5814  2010-06-08 13:12  TxtToMulSheets\TxtToMulSheets\Frm_Main.resx
     文件         498  2010-06-08 13:11  TxtToMulSheets\TxtToMulSheets\Program.cs
     文件        3971  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\TxtToMulSheets.csproj
     文件     1100392  2007-10-10 09:48  TxtToMulSheets\TxtToMulSheets\bin\Debug\Microsoft.Office.Interop.Excel.dll
     文件       11776  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\bin\Debug\TxtToMulSheets.exe
     文件       32256  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\bin\Debug\TxtToMulSheets.pdb
     文件       14328  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets\bin\Debug\TxtToMulSheets.vshost.exe
     文件         490  2009-06-11 05:14  TxtToMulSheets\TxtToMulSheets\bin\Debug\TxtToMulSheets.vshost.exe.manifest
     文件        2523  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\obj\Debug\TxtToMulSheets.csproj.FileListAbsolute.txt
     文件         850  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\obj\Debug\TxtToMulSheets.csproj.GenerateResource.Cache
     文件       11776  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\obj\Debug\TxtToMulSheets.exe
     文件         180  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\obj\Debug\TxtToMulSheets.Frm_Main.resources
     文件       32256  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\obj\Debug\TxtToMulSheets.pdb
     文件         180  2010-11-03 16:26  TxtToMulSheets\TxtToMulSheets\obj\Debug\TxtToMulSheets.Properties.Resources.resources
     文件        1360  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets\Properties\AssemblyInfo.cs
     文件        2878  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets\Properties\Resources.Designer.cs
     文件        5612  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets\Properties\Resources.resx
     文件        1099  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets\Properties\Settings.Designer.cs
     文件         249  2010-06-08 13:09  TxtToMulSheets\TxtToMulSheets\Properties\Settings.settings