Remove entries before excel column headers

[RPA-botDev (RPA)]

Hi Devs, I want to write an excel file to another sheet, but there are entries before the column headers which I don’t need.How do I remove them please?

[Robinnavinraj_S]

Can you share your excel file and expected output as sample

[pravin_calvin (pravin kumar)]

Hi @RPA-botDev

Is the rows before the column headers are fixed then we can try with below expression

DT.AsEnumerable.Skip(rows you need to Skip as number).CopyToDatable

and Write range to new excel

Regards

[RPA-botDev (RPA)]

Alright Pravin, I’ll try that out