//选取排序区域
exRange = xlsSheet.Range[string.Format("A2:{0}", getXlsCellName(tRows, tCols + 1))];
Application.DoEvents();
//设定排序列
Excel.Range rgSort = xlsSheet.Columns[tCols + 1];
Application.DoEvents();
//调用排序方法
exRange.Sort(rgSort, Excel.XlSortOrder.xlDescending, Type.Missing, Type.Missing, Excel.XlSortOrder.xlAscending
, Type.Missing, Excel.XlSortOrder.xlAscending
, Excel.XlYesNoGuess.xlNo, Type.Missing, Type.Missing,
Excel.XlSortOrientation.xlSortColumns,
Excel.XlSortMethod.xlPinYin,
Excel.XlSortDataOption.xlSortNormal,
Excel.XlSortDataOption.xlSortNormal,
Excel.XlSortDataOption.xlSortNormal);
Application.DoEvents();