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

Rupesh Kahane

6y2.7k.NET

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leon D6y ago
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
0
Dinesh Gabhane6y ago
1. //Option 1
2. var row = sheet.CreateRow(0);
3. row.Cells[targetColumn].SetCellValue("ValueNeedToSelect");
5. //Option 2
6. var namedRow = wb.GetSheetAt(sheetIndex).CreateRow(rowindex);
7. namedRow.CreateCell(columnIndex).SetCellValue("ValueNeedToSelect");
9. //Option 3
10. var namedRow1 = wb.GetSheetAt(0).GetRow(rowindex);
11. 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/
0
Rajanikant Hawaldar6y ago
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
0