操作excel的记忆1

最新推荐文章于 2024-09-13 16:43:43 发布

whwqs

最新推荐文章于 2024-09-13 16:43:43 发布

阅读量596

点赞数

分类专栏：记忆文章标签： excel string button object null

本文链接：https://blog.csdn.net/whwqs/article/details/4028241

版权

记忆专栏收录该内容

34 篇文章 0 订阅

订阅专栏

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;
        }