I can't add data validation to excel using javascript
But i have Example C# code and library
Example Syntag
private void SetValidation()
{
Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
this.Controls.AddNamedRange(this.Range["A1", missing],
"namedRange1");
namedRange1.Validation.Add(
Excel.XlDVType.xlValidateTextLength,
Excel.XlDVAlertStyle.xlValidAlertStop,
Excel.XlFormatConditionOperator.xlGreater, 3, missing);
namedRange1.Validation.InputMessage = "Enter a name.";
namedRange1.Validation.ErrorMessage =
"Please enter a name with 3 or more characters.";
}
But i have Example C# code and library
Example Syntag
private void SetValidation()
{
Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
this.Controls.AddNamedRange(this.Range["A1", missing],
"namedRange1");
namedRange1.Validation.Add(
Excel.XlDVType.xlValidateTextLength,
Excel.XlDVAlertStyle.xlValidAlertStop,
Excel.XlFormatConditionOperator.xlGreater, 3, missing);
namedRange1.Validation.InputMessage = "Enter a name.";
namedRange1.Validation.ErrorMessage =
"Please enter a name with 3 or more characters.";
}