Hey,
we imported an external Excel file into a Infragistics.Documents.Excel.Worksheet.
Some cells contains a dropdown list.
How can we get the linked elemnets (like ValueList) or set the Value not like text but as an index of the dropdownlist (DataValidationRule is null / Value Type is string)
Thanks for your help!
Hello,
Cells have a Value property.
eg.
// Define allowed values string[] allowedValues = { "Red", "Green", "Blue" };
// Create the dropdown list rule ListDataValidationRule dropdownRule = new ListDataValidationRule(); dropdownRule.SetValues(allowedValues);
// Apply rule to cell A1 WorksheetCell cell = sheet.Rows[14].Cells[0]; cell.DataValidationRule = dropdownRule;
// Set the value to one of the allowed items cell.Value = "Green"; // This is valid and will pass validation
Hey Michael,
thanks for your answer.
Our problem is, that cells of the external Excel-File has a dropdown-list (in Excel / source like “=Kataloge!$B$2:$B$3”) but we could not get the allowed values by reading this external Excel-File with Infragistics ExcelEngine.
The Type of the Infragistics.Documents.Excel.WorksheetCell is string and this cell has no DataValidationRule.
Is there another opportunity to get the allowed values or the source value?