Count (属性)

返回一个 int 值，它代表集合中对象的数量。

示例

python

# 此示例显示 Sheet1 上选定区域中的列数。此示例还将检测选定区域中是否包含多重选定区域，如果包含，则对多重选定区域中每一子区域进行循环
def test():
    Application.Worksheets.Item("Sheet1").Activate()
    iAreaCount = Application.Selection.Areas.Count

    if iAreaCount <= 1:
        print("The selection contains " + Application.Selection.Columns.Count + " columns.")
    else:
        for i in range(1, iAreaCount):
            print("Area " + i + " of the selection contains " + Application.Selection.Areas.Item(i).Columns.Count + " columns.")