Excel column as dropdown

Rahul try this:

DataTable table = ...
 
// Create new excel file and insert a DataTable.
var excel = new ExcelFile();
var sheet = excel.Worksheets.Add(table.TableName);
sheet.InsertDataTable(table);
 
// Cell(s) where the DropDownList(s) will be located.
var listCells = sheet.Cells.GetSubrange("M1", "M1");
 
sheet.DataValidations.Add(new DataValidation(listCells)
{
    Type = DataValidationType.List,
    // DropDownList values, as an example this one refers to column "C".
    Formula1 = "=$C:$C"
});
 
excel.Save("Sample.xlsx");

The code uses this C# library for excel files.
You can directly import your DataTables to excel in .NET and you can easily add DropDownList via DataValidation.

Hi Rahul Rao,

Read these links it helps you

http://www.c-sharpcorner.com/UploadFile/kbpatel/how-to-create-a-dropdown-list-to-an-excel-using-C-Sharp/

http://www.c-sharpcorner.com/Blogs/7482/retrieving-excel-data-and-binding-to-a-combobox-in-C-Sharp.aspx