Asp – How to add dropdown in column of excel sheet programmatically with Excel.Package

jQuery's documentation states:

[jQuery.val] checks, or selects, all the radio buttons, checkboxes, and select options that match the set of values.

This behavior is in jQuery versions 1.2 and above.

You most likely want this:

$("._statusDDL").val('2');

You can use Excel COM objects to create Excel sheets in ASP.NET.

Try this link.