by
0
7
4,350
8
Top 1% !
Popular
Famous
Tagged
Easy-to-find
Specified
OpenSource
Popularity: 2250th place
Created
Modified Nov 19, 2013

Published on:

LanguageCsharp
LicenseMIT_X11

How to bind a validation list to a cell of Excel file in Csharp

This c# method allows to define a validation list of entries (as string, using comma [,] as separator character) to bind to a specific cell for a sheet in an xls file (Microsoft Excel compatible). The validation list appears as a dropdown menu, where the user can choose the content from.
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/614/How-to-bind-a-validation-list-to-a-cell-?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
enum Result { Passed, Partially_Passed, Failed, Blocked, Not_Applicable, Not_Tested } /// <summary> /// This method creates a Excel validation list for the selected cell, and associate the list to the cell (dropdown combo box) /// </summary> /// <param name="ws">Excel worksheet</param> /// <param name="excel_CellToValidate">Cell to validate</param> /// <param name="listForValidation">List of data to use for validation</param> private void Excel_createCellValidationDropDownList(Worksheet ws, string excel_CellToValidate, string listForValidation) { ws.get_Range(excel_CellToValidate, excel_CellToValidate).Cells.Validation.Delete(); ws.get_Range(excel_CellToValidate, excel_CellToValidate).Cells.Validation.Add( XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertInformation, XlFormatConditionOperator.xlBetween, listForValidation, Type.Missing); } //Example of usage string m_excelList = string.Join(",", Enum.GetNames(typeof(Result))); this.Excel_createCellValidationDropDownList(ws, "C1", m_excelList);
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus