How to insert the certain Row in between the Existing Excel Sheet

[Haarish_S]

DataTable Example :

saara 67 woking
sam 24 working
sandy 30 working
selvi 40 woking

Need output like :

my row
saara 67 woking
my row
sam 24 working
my row
sandy 30 working
my row
selvi 40 woking

[supriya117 (Supriya Allada)]

Hi @Haarish_S

Try this:

1. Read excel file as dt
2. Use assign activity

modifiedDataTable = (From row In dt.AsEnumerable()
                             Select newRow, row).SelectMany(Function(x) {x.newRow, x.row}).CopyToDataTable()

Here newRow is a datarow that you want to pass.
3. Use write range workbook to copy the data to excel.

Hope it helps.