How to sort the selected rows in excel using c#.net?

See more:

C#

.NET

MS-Excel

Hai friends I need to sort selected range in excel, I workout this in VBA macro it works, but I convert it to c# it throw the exception.

the Exception message shows
The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort By box isn't the same or blank.

VBA CODING:

Range("C232:C342").Select
ActiveWorkbook.Worksheets("Headword_list").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Headword_list").Sort.SortFields.Add Key:=Range("C2"), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Headword_list").Sort
     .SetRange Range("A232:M342")
     .Header = xlNo
     .MatchCase = False
     .Orientation = xlTopToBottom
     .SortMethod = xlPinYin
     .Apply
End With

my C# code:

xlWorkSheet.Sort.SortFields.Add(bcrRange[rcnt, 3], Excel.XlSortOn.xlSortOnValues, Excel.XlSortOrder.xlAscending, Type.Missing, Excel.XlSortDataOption.xlSortNormal);

xlWorkSheet.Sort.SetRange(bcrRange);
xlWorkSheet.Sort.MatchCase = false;
xlWorkSheet.Sort.Header = Excel.XlYesNoGuess.xlNo;
xlWorkSheet.Sort.Orientation = Excel.XlSortOrientation.xlSortRows;
xlWorkSheet.Sort.SortMethod = Excel.XlSortMethod.xlPinYin;
xlWorkSheet.Sort.Apply();

how to solve it I need to sort the excel selected range in ascending order based on column 3. any one have solution?