C#读取Excel

		private void OpenExcel()
        {

            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Title = "打开";
            ofd.Filter = "excel files(*.xlsx)|*.xlsx";
            ofd.Multiselect = true;
            ofd.FileName = Model_FilePath.BdfPath;
            ofd.InitialDirectory = Model_FilePath.WorkPath + "excel_csv";
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                FlightPathDataReader ec = new FlightPathDataReader();
                if (Path.GetExtension(ofd.FileNames[0]).ToLower() == ".csv" || Path.GetExtension(ofd.FileNames[0]).ToLower() == ".txt")
                {
                    ec.LoadCSVFilesData(ofd.FileNames);
             
                }
                else if (Path.GetExtension(ofd.FileName).ToLower() == ".xls" || Path.GetExtension(ofd.FileName).ToLower() == ".xlsx")
                {
                    List<DataTable> ds = CALT_Excel.MicrosoftExcel.Dll_Reader.LoadExcel(ofd.FileName);
                    DataTable dt = ds[0];
                }
 		}

		public static List<System.Data.DataTable>   LoadExcel(string filename)
        {

            var mode = ReadMode;
            if (mode < 0 || mode > ExcelReadMode.AppReader)
                mode = ExcelReadMode.ExcelReader;
            switch (mode)
            {
                case ExcelReadMode.ExcelReader:
                    return ExcelReaderHelper.DefaultGetExcelDataTables(filename, true);
                case ExcelReadMode.XPort:
                case ExcelReadMode.DevExpress:
                    return ExcelxPortHelper.DefaultGetExcelDataTables(filename, true);
                    //return ExcelDxBHelper.DefaultGetExcelDataTables(filename, true);
                case ExcelReadMode.OLEDB:
                    return ExcelOLEDBHelper.DefaultGetExcelDataTables(filename, true);
                case ExcelReadMode.AppReader:
                    return ExcelAppReader(filename);
                default:
                    return ExcelReaderHelper.DefaultGetExcelDataTables(filename, true);
            }
        }
        
     	public bool LoadCSVFilesData(string[] filePath)
        {
            m_data.New();
            m_data.Clear();

            for (int i = 0; i < filePath.Length;i++ )
            {
                if (i>3)
                {
                    return true;
                }
                if (File.Exists(filePath[i]))
                {
                    LoadCSVFileData(filePath[i], i);
                    m_data.m_FilePath.Add( filePath[i]);
                }
                else
                {
                    return false;
                }
            }
            return true;
        }