Remove entries before excel column headers

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?

Can you share your excel file and expected output as sample

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


1 Like

Alright Pravin, I’ll try that out