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

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

        private void tsbtn_Open_Click（object sender EventArgs e）
        {
            OpenFileDialog openFile = new OpenFileDialog（）;//实例化打开对话框对象
            openFile.Filter = “Excel文件|*.xls“;//设置打开文件筛选器
            openFile.title = “打开Excel模板“;//设置打开对话框标题
            openFile.InitialDirectory = Application.StartupPath;//设置初始路径
            if （openFile.ShowDialog（） == DialogResult.OK）//判断是否选择了文件
            {
                tstxt_Excel.Text=openFile.FileName;
                WBrowser_Excel.Navigate（openFile.FileName）;//在窗体中显示Excel文件内容
                List P_list_SheetNames = GetSheetName（

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件         929  2010-06-19 10:43  CalMultiSheet\CalMultiSheet.sln
     文件       16896  2010-11-03 16:55  CalMultiSheet\CalMultiSheet.suo
     文件        4166  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\CalMultiSheet.csproj
     文件       11921  2010-06-19 13:38  CalMultiSheet\CalMultiSheet\Frm_Main.cs
     文件       12846  2010-06-19 13:38  CalMultiSheet\CalMultiSheet\Frm_Main.designer.cs
     文件        6211  2010-06-19 13:38  CalMultiSheet\CalMultiSheet\Frm_Main.resx
     文件         497  2010-06-19 10:46  CalMultiSheet\CalMultiSheet\Program.cs
     文件       17920  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\bin\Debug\CalMultiSheet.exe
     文件       36352  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\bin\Debug\CalMultiSheet.pdb
     文件       14328  2010-06-19 10:43  CalMultiSheet\CalMultiSheet\bin\Debug\CalMultiSheet.vshost.exe
     文件         490  2009-06-11 05:14  CalMultiSheet\CalMultiSheet\bin\Debug\CalMultiSheet.vshost.exe.manifest
     文件       13824  2010-06-26 09:28  CalMultiSheet\CalMultiSheet\bin\Debug\Excel1.xls
     文件       13824  2010-06-26 09:28  CalMultiSheet\CalMultiSheet\bin\Debug\Excel2.xls
     文件       13824  2010-06-26 09:28  CalMultiSheet\CalMultiSheet\bin\Debug\Excel3.xls
     文件     1100392  2007-10-10 09:48  CalMultiSheet\CalMultiSheet\bin\Debug\Microsoft.Office.Interop.Excel.dll
     文件       13824  2010-06-26 09:28  CalMultiSheet\CalMultiSheet\bin\Debug\Sum.xls
     文件       13824  2010-06-26 09:28  CalMultiSheet\CalMultiSheet\bin\Debug\模板文件.xls
     文件        2475  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\obj\Debug\CalMultiSheet.csproj.FileListAbsolute.txt
     文件         934  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\obj\Debug\CalMultiSheet.csproj.GenerateResource.Cache
     文件       17920  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\obj\Debug\CalMultiSheet.exe
     文件         180  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\obj\Debug\CalMultiSheet.Frm_Main.resources
     文件       36352  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\obj\Debug\CalMultiSheet.pdb
     文件        1689  2010-11-03 16:55  CalMultiSheet\CalMultiSheet\obj\Debug\CalMultiSheet.Properties.Resources.resources
     文件        8724  2010-06-19 13:07  CalMultiSheet\CalMultiSheet\obj\Debug\ResolveAssemblyReference.cache
     文件        5120  2010-06-19 10:58  CalMultiSheet\CalMultiSheet\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll
     文件        1358  2010-06-19 10:43  CalMultiSheet\CalMultiSheet\Properties\AssemblyInfo.cs
     文件        3360  2010-06-19 10:58  CalMultiSheet\CalMultiSheet\Properties\Resources.Designer.cs
     文件        6449  2010-06-19 10:58  CalMultiSheet\CalMultiSheet\Properties\Resources.resx
     文件        1098  2010-06-19 10:43  CalMultiSheet\CalMultiSheet\Properties\Settings.Designer.cs
     文件         249  2010-06-19 10:43  CalMultiSheet\CalMultiSheet\Properties\Settings.settings
     文件        2862  2010-06-19 10:56  CalMultiSheet\CalMultiSheet\Resources\open.ico
............此处省略2个文件信息