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

Excel column as dropdown

Answers (3)