Excel column as dropdown

Question

Hi I am exporting data from a table to excel file after that i have to make a excel column as dropdownlist using c#. Thanks & Regards Rahul Rao .

Jacke Elis · Answer

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.

Manish Kumar Choudhary · Answer

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

Shweta Lodha · Answer

Rahul Rao Please have a look at this: https://social.msdn.microsoft.com/Forums/office/en-US/8470cf52-c96e-4bc1-af98-6e98022bc77e/how-to-create-dropdownlist-in-excel-on-the-fly-in-c?forum=vsto