Microsoft.Office.Interop.Excel.Application excel=NewMicrosoft.Office.Interop.Excel.Application (); Microsoft.Office.Interop.Excel.Workbooks Workbooks=Excel. Workbooks; Microsoft.Office.Interop.Excel.Workbook Workbook=Workbooks.Add (Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); Microsoft.Office.Interop.Excel.WorkSheet WorkSheet=(Microsoft.Office.Interop.Excel.Worksheet) workbook. worksheets[1];((Microsoft.Office.Interop.Excel.Range range_col=(Microsoft.Office.Interop.Excel.Range) worksheet. Columns.get_item (1, Type.Missing);//load drop-down list contentsstringName=getname (DataTable);//the DataTable isolatedRange_Col.Validation.Add (Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, microsoft.office.interop.excel.xlformatconditionoperator.xlbetween,name,type.missing);//name is the list obtained abovePrivate stringGetName (DataTable dt) {varList=dt. AsEnumerable (). Select (t=>t.field<string> ("Name")). ToList (); return string. Join (",", List. ToArray ()); }
C # dynamically add drop-down options to Excel columns