DataValidations dataValidations1 = new DataValidations();
DataValidation dataValidation2 = new DataValidation() { Type = DataValidationValues.List, AllowBlank = true, ShowInputMessage = true, ShowErrorMessage = true, SequenceOfReferences = new ListValue<stringvalue>() { InnerText = "A4:B4" } };
Formula1 formula12 = new Formula1();
formula12.Text = "$A$1:$A$3";
dataValidations1.Append(dataValidation1);
worksheet1.Append(dataValidations1);
In the above code will add dropdownlist in excel .I've doubt for dropdown how they are adding values . pls suggest .
if my table having raja,ram,raju,bala,guna in list how should i add this in dropdown list ?
ListValue<stringvalue>