Excel with c#: Exculde first rows when copying a r

Question

The following command copied the complete used range into the clipboard:

                mySheet.UsedRange.Copy();

I want to just exculde the first row and copy the rest into clip board. Please help

Answer 1

You could try to get it with something like this:

Excel.Range dataWithoutFirstRow = mySheet.Range[mySheet.UsedRange.Cells[2, 1],
      mySheet.UsedRange.SpecialCells(Excel.XlCellType.xlCellTypeLastCell)];