C# 循环 Range.Value，它有 2 个对象 [0,0] 来查找字符串是否 = 变量

发布于 2024-11-04 18:00:26 字数 524 浏览 4 评论 0原文

我正在使用 Aspose.Cells 并且创建了一个单元格范围。该范围生成一个 range.Value，其中包含 2 个对象 [row,column]。我现在想要循环这些对象，在我的例子中，这些对象有 1 行和 33 列，每列都插入了一个字符串“day”。

所以基本上我想循环并添加一个 if 语句，例如

          if (range.Value.ToString() == "Sat")
            {
                range.ApplyStyle(backgroundColour, flg);
            }

我是否必须循环 33 个对象（列）？

每个范围值表达式看起来都像 ((object[,])(range.Value))[0, 0] ，本例中的值是 Fri，然后是 ((object[,] )(range.Value))[0, 1] 其中值为 Sat，依此类推。

原文

I am using Aspose.Cells and I have created a Range of cells. This range produces a range.Value which consists of 2 objects [row,column]. I now want to loop round these objects which in my case is 1 row and 33 columns with each column having a string 'day' inserted.

So basically I want to loop round and add an if statement such as

          if (range.Value.ToString() == "Sat")
            {
                range.ApplyStyle(backgroundColour, flg);
            }

Do I someway have to loop the 33 objects(columns)?

Each range value expression looks like ((object[,])(range.Value))[0, 0] whew the value in this case is Fri and then ((object[,])(range.Value))[0, 1] where the value is Sat and so on.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

披肩女神 2024-11-11 18:00:26

您可以像这样迭代整个范围：

    object[,] rng = (object[,])range.Value;

    for (int row = rng.GetLowerBound(0); row <= rng.GetUpperBound(0); row++)
    {
        for (int day = rng.GetLowerBound(1); day <= rng.GetUpperBound(1); day++)
        {
            string dayName = rng[row,day] as string;
        }
    }

You can iterate over the whole range like this:

    object[,] rng = (object[,])range.Value;

    for (int row = rng.GetLowerBound(0); row <= rng.GetUpperBound(0); row++)
    {
        for (int day = rng.GetLowerBound(1); day <= rng.GetUpperBound(1); day++)
        {
            string dayName = rng[row,day] as string;
        }
    }

回复收藏 0 原文

~没有更多了~