操作excel的记忆1

private void button1_Click(object sender, EventArgs e)
        {
            string s = "";
            int i=1;
            do
            {
                System.Array array = this.Range["a" + i.ToString(), "q" + i.ToString()].Cells.Value2 as System.Array;
                string[] arr2 = this.ConvertToStringArray(array);
                if (arr2.Any<string>(p => !string.IsNullOrEmpty(p)))
                {
                    s += arr2[0];
                    i++;
                }
                else
                {
                    break;
                }
                

            } while (true);
            this.textBox1.Text = s;
            
        }

        private string[] ConvertToStringArray(System.Array values)
        {

            // create a new string array
            string[] theArray = new string[values.Length];

            // loop through the 2-D System.Array and populate the 1-D String Array
            for (int i = 1; i <= values.Length; i++)
            {
                if (values.GetValue(1, i) == null)
                    theArray[i - 1] = "";
                else
                    theArray[i - 1] = (string)values.GetValue(1, i).ToString();
            }

            return theArray;
        }