C#動態給EXCEL列添加下拉選項

標籤：

Microsoft.Office.Interop.Excel.Application excel=new Microsoft.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);//載入下拉式清單內容string Name=GetName(DataTable);//查出的DataTableRange_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就是上面擷取的列表private string GetName（DataTable dt）{    var list=dt.AsEnumerable().Select(t=>t.Field<string>("Name")).ToList();    return string.Join(",",list.ToArray());  }　　

 

C#動態給EXCEL列添加下拉選項