C＃OLEDB Excel Reader对象到数组

Question

我有一个具有70k行的Excel，我将对数据进行一些计算。

我编写了此代码以将Excel值获取到var对象中，哪种类型为{double}。我想将其拆开成一个数组来使用值，或者是否还有其他解决方案可以使用它。

private string FileName = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Master.xlsx");

    public string ConnectionString(string FileName, string Header)
    {
        OleDbConnectionStringBuilder Builder = new OleDbConnectionStringBuilder();
        if (System.IO.Path.GetExtension(FileName).ToUpper() == ".XLS")
        {
            Builder.Provider = "Microsoft.Jet.OLEDB.4.0";
            Builder.Add("Extended Properties", string.Format("Excel 8.0;IMEX=1;HDR={0};", Header));
        }
        else
        {
            Builder.Provider = "Microsoft.ACE.OLEDB.12.0";
            Builder.Add("Extended Properties", string.Format("Excel 12.0;IMEX=1;HDR={0};", Header));
        }

        Builder.DataSource = FileName;

        return Builder.ConnectionString;
    }

    private void button1_Click(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        using (OleDbConnection con = new OleDbConnection { ConnectionString = ConnectionString(FileName, "Yes") })
        {
            con.Open();
            using (OleDbCommand cmd = new OleDbCommand { CommandText = "SELECT * FROM [INJECTION Data$]", Connection = con })
            {
                OleDbDataReader dr = cmd.ExecuteReader();
                dt.Load(dr);
                var rowDataArray = dt.Rows.Cast<DataRow>().Select(x => new[] { x[0] });
            }
            
        }
        
    }

Answer 1

感谢@jdweng

private void button1_Click(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        using (OleDbConnection con = new OleDbConnection { ConnectionString = ConnectionString(FileName, "Yes") })
        {
            con.Open();
            //using (OleDbCommand cmd = new OleDbCommand { CommandText = "SELECT F1, F2, F3 FROM [Sheet1$]", Connection = con })
            using (OleDbCommand cmd = new OleDbCommand { CommandText = "SELECT * FROM [INJECTION Data$]", Connection = con })
            {
                OleDbDataReader dr = cmd.ExecuteReader();
                dt.Load(dr);
                var rowDataArray = dt.Rows.Cast<DataRow>().Select(x => new[] { x[0] });
                double[] a = new double[dt.Rows.Count];

                for(int i = 0; i <dt.Rows.Count ; i++)
                {
                    a[i] = Convert.ToDouble(dt.Rows[i].ItemArray[0]);
                    
                } 
            }  
        }
    }