bind drop down list .xlsx excel in C# & make selected item

Question

I would like bind the drop down list in excel & would like to select item as well using c#. For report I am using .xlsx file Suppose I have employee list Rupesh Sameer Ashish Amol I have an web application contains this drop down list while submit the data suppose I am selecting a record Sameer & saved it into a database. Now while export the data into a excel I need records of employee name as a drop down list & make "Sameer" selected in that excel. Example

Dinesh Gabhane · Answer

//Option 1 var row = sheet.CreateRow(0); row.Cells[targetColumn].SetCellValue( "ValueNeedToSelect" ); // Option 2 var namedRow = wb.GetSheetAt(sheetIndex).CreateRow(rowindex); namedRow.CreateCell(columnIndex).SetCellValue( " ValueNeedToSelect " ); // Option 3 var namedRow1 = wb.GetSheetAt(0).GetRow(rowindex); namedRow1.Cells[targetColumn].SetCellValue( " ValueNeedToSelect " ); For select the dropdown item try above code Please go through below article https://www.c-sharpcorner.com/UploadFile/kbpatel/how-to-create-a-dropdown-list-to-an-excel-using-C-Sharp/

Leon D · Answer

Check this link: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/NET-Dropdown-List-Create-Excel-Dropdown-List-in-C-and-VB.NET.html

Rajanikant Hawaldar · Answer

Hi Rupesh, this two below links may help you. https://www.c-sharpcorner.com/UploadFile/kbpatel/how-to-create-a-dropdown-list-to-an-excel-using-C-Sharp/ https://stackoverflow.com/questions/25659888/add-dropdown-list-in-the-excel-sheet-using-c-sharp