I have the following line of code, which sorts data in the worksheet according to specific columns, ascending. The problem is, it takes the very first row into account (cells A1, B1, etc).
worksheet.Cells["A:AA"].Sort(new int[] { 5, 10 }, new bool[] { false, false });
What ExcelRange should I specify in order to take into account only cells below the first row?
This does the trick:
worksheet.Cells["A2:AA"].Sort(new int[] { 5, 10 }, new bool[] { false, false });