Rupesh Kahane

Rupesh Kahane

  • 102
  • 19.1k
  • 4.2m

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

Dec 2 2019 2:59 AM
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 
 

Answers (3)