实时读取不同数据到Excel进行汇总处理

实时读取不同数据到Excel进行汇总处理-例1(Excel入门级源码).zip

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.Data.OleDb;

namespace DisDataToExcel
{
    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;/

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件    57423572  2010-08-13 16:17  实时读取不同数据到Excel进行汇总处理.exe
     文件         932  2010-06-19 08:45  DisDataToExcel\DisDataToExcel.sln
     文件       17920  2010-11-03 16:49  DisDataToExcel\DisDataToExcel.suo
     文件        4098  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\DisDataToExcel.csproj
     文件       11660  2010-06-19 15:58  DisDataToExcel\DisDataToExcel\Frm_Main.cs
     文件       13885  2010-06-19 15:58  DisDataToExcel\DisDataToExcel\Frm_Main.Designer.cs
     文件        6008  2010-06-19 15:58  DisDataToExcel\DisDataToExcel\Frm_Main.resx
     文件         498  2010-06-19 14:43  DisDataToExcel\DisDataToExcel\Program.cs
     文件       16896  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\bin\Debug\DisDataToExcel.exe
     文件       38400  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\bin\Debug\DisDataToExcel.pdb
     文件       14328  2010-06-19 08:45  DisDataToExcel\DisDataToExcel\bin\Debug\DisDataToExcel.vshost.exe
     文件         490  2009-06-11 05:14  DisDataToExcel\DisDataToExcel\bin\Debug\DisDataToExcel.vshost.exe.manifest
     文件     1100392  2007-10-10 09:48  DisDataToExcel\DisDataToExcel\bin\Debug\Microsoft.Office.Interop.Excel.dll
     文件      662120  2007-10-10 09:48  DisDataToExcel\DisDataToExcel\bin\Debug\Microsoft.Office.Interop.Word.dll
     文件        2717  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\obj\Debug\DisDataToExcel.csproj.FileListAbsolute.txt
     文件         850  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\obj\Debug\DisDataToExcel.csproj.GenerateResource.Cache
     文件       16896  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\obj\Debug\DisDataToExcel.exe
     文件         180  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\obj\Debug\DisDataToExcel.Frm_Main.resources
     文件       38400  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\obj\Debug\DisDataToExcel.pdb
     文件         180  2010-11-03 16:47  DisDataToExcel\DisDataToExcel\obj\Debug\DisDataToExcel.Properties.Resources.resources
     文件       11419  2010-06-19 15:39  DisDataToExcel\DisDataToExcel\obj\Debug\ResolveAssemblyReference.cache
     文件        1360  2010-06-19 08:44  DisDataToExcel\DisDataToExcel\Properties\AssemblyInfo.cs
     文件        2878  2010-06-19 08:44  DisDataToExcel\DisDataToExcel\Properties\Resources.Designer.cs
     文件        5612  2010-06-19 08:44  DisDataToExcel\DisDataToExcel\Properties\Resources.resx
     文件        1099  2010-06-19 08:44  DisDataToExcel\DisDataToExcel\Properties\Settings.Designer.cs
     文件         249  2010-06-19 08:44  DisDataToExcel\DisDataToExcel\Properties\Settings.settings