Datagridview copy paste in c# winform

Create datagrid view with four column Srno, Category, ID and Consider. Need to copy and paste from excel to Category and ID column(Either Single or multiple column copy paste). Sr number should be generated automatically.

SrNo Category ID Consider
1 AA00 1110-2200 Yes
2 AB01 101-3200 No
3 AC03 101-3201 Yes