如何使用C#在Excel中的另一个工作表上从名称范围创建验证? [英] How to create validation from name range on another worksheet in excel using C#?

问题描述

我在工作表"A"上创建了名称范围，因此我需要将此范围用作工作表B上的验证组合框.我想知道如何使用C#将验证设置为范围?

I have create name range on sheet "A" so I need to use this range as validation ComboBox on sheet B. I want to know how can I setting validation as range using C#?

推荐答案

工作表无关紧要，因为您将只引用列表值范围的命名范围.在这里，您进入下面(假设互操作)-listValidatingRange是您需要在下拉菜单中显示您的值的地方-将其添加为命名范围. cellThatNeedsValidating是您希望下拉菜单出现的单元格-将其添加为命名范围.然后，在cellThatNeedsValidating上，添加验证为"=ListValidatingRange".

The sheets won't matter because you'll just reference the named range of the list value range. Here you go below (assumes Interop) - listValidatingRange is where you have your values that need to be displayed in the dropdown - add that as a named range. cellThatNeedsValidating is the cell that you want the drop-down to appear in - add that as a named range. Then, on cellThatNeedsValidating, add the validation to be that of "=ListValidatingRange".

private void SetValidation()
{

    Microsoft.Office.Tools.Excel.NamedRange listValidatingRange =
        this.Controls.AddNamedRange(this.Range[""C1:C13"", missing],
        "ListValidatingRange");

    Microsoft.Office.Tools.Excel.NamedRange cellThatNeedsValidating =
        this.Controls.AddNamedRange(this.Range[""A1"", missing],
        "cellThatNeedsValidating");

    cellThatNeedsValidating.Validation.Add(
        Excel.XlDVType.xlValidateList ,
        Excel.XlDVAlertStyle.xlValidAlertStop,
        missing, "=ListValidatingRange", missing);
}

这篇关于如何使用C#在Excel中的另一个工作表上从名称范围创建验证?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！