抓取价格EXcel导入导出

抓取指定面上的价格并导入到Excel表中

using System.Data.OleDb;
using System.Data;
using System;
using System.Collections.Generic;
using System.xml.Linq;
using System.IO;
class ExcelReader
    {
        private string fileName;
        private string sheetName;
        private bool firstRowAsHeader;
        private bool mixedDataType = true;
        private string sheetRange = string.Empty;
        private OleDbConnection excelConnection;
        private OleDbCommand excelCommand;
        public ExcelReader（string fileName）
        {
            this.fileName = fileName;
        }
        public ExcelReader（string fileName string sheetName） : this（fileName sheetName false true） { }
        public ExcelReader（string fileName string sheetName bool firstRowAsHeader） : this（fileName sheetName firstRowA

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        117  2013-11-23 15:49  catch_jd\catch_jd\app.config

     文件      22528  2013-11-29 11:09  catch_jd\catch_jd\bin\Debug\catch_jd.exe

     文件        117  2013-11-23 15:49  catch_jd\catch_jd\bin\Debug\catch_jd.exe.config

     文件      44544  2013-11-29 11:09  catch_jd\catch_jd\bin\Debug\catch_jd.pdb

     文件      11608  2013-11-29 08:46  catch_jd\catch_jd\bin\Debug\catch_jd.vshost.exe

     文件        117  2013-11-23 15:49  catch_jd\catch_jd\bin\Debug\catch_jd.vshost.exe.config

     文件        490  2010-03-18 12:39  catch_jd\catch_jd\bin\Debug\catch_jd.vshost.exe.manifest

     文件     200704  2013-03-06 07:13  catch_jd\catch_jd\bin\Debug\ICSharpCode.SharpZipLib.dll

     文件      52736  2013-04-26 02:36  catch_jd\catch_jd\bin\Debug\LitJson.dll

     文件     440320  2013-10-17 12:51  catch_jd\catch_jd\bin\Debug\Newtonsoft.Json.dll

     文件    1263104  2013-10-17 12:51  catch_jd\catch_jd\bin\Debug\Newtonsoft.Json.pdb

     文件     508735  2013-10-17 12:51  catch_jd\catch_jd\bin\Debug\Newtonsoft.Json.xml

     文件    1624064  2013-03-06 07:17  catch_jd\catch_jd\bin\Debug\NPOI.dll

     文件     387072  2013-03-06 07:17  catch_jd\catch_jd\bin\Debug\NPOI.OOxml.dll

     文件      79872  2013-03-06 07:17  catch_jd\catch_jd\bin\Debug\NPOI.Openxml4Net.dll

     文件    1316864  2013-03-06 07:17  catch_jd\catch_jd\bin\Debug\NPOI.OpenxmlFormats.dll

     文件    2144246  2013-03-06 07:17  catch_jd\catch_jd\bin\Debug\NPOI.xml

     文件      21504  2013-11-29 11:46  catch_jd\catch_jd\bin\Release\catch_jd.exe

     文件        117  2013-11-23 15:49  catch_jd\catch_jd\bin\Release\catch_jd.exe.config

     文件      40448  2013-11-29 11:46  catch_jd\catch_jd\bin\Release\catch_jd.pdb

     文件     200704  2013-03-06 07:13  catch_jd\catch_jd\bin\Release\ICSharpCode.SharpZipLib.dll

     文件      52736  2013-04-26 02:36  catch_jd\catch_jd\bin\Release\LitJson.dll

     文件     440320  2013-10-17 12:51  catch_jd\catch_jd\bin\Release\Newtonsoft.Json.dll

     文件    1263104  2013-10-17 12:51  catch_jd\catch_jd\bin\Release\Newtonsoft.Json.pdb

     文件     508735  2013-10-17 12:51  catch_jd\catch_jd\bin\Release\Newtonsoft.Json.xml

     文件    1624064  2013-03-06 07:17  catch_jd\catch_jd\bin\Release\NPOI.dll

     文件     387072  2013-03-06 07:17  catch_jd\catch_jd\bin\Release\NPOI.OOxml.dll

     文件      79872  2013-03-06 07:17  catch_jd\catch_jd\bin\Release\NPOI.Openxml4Net.dll

     文件    1316864  2013-03-06 07:17  catch_jd\catch_jd\bin\Release\NPOI.OpenxmlFormats.dll

     文件    2144246  2013-03-06 07:17  catch_jd\catch_jd\bin\Release\NPOI.xml

............此处省略1843个文件信息