How to paste datatable in word without Column0, Column1

[supermanPunch (Arpan)]

@markosc

I have to paste the datatable to word without headers.

Hi @markosc ,

To Perform this, we actually would need some external c# or vb.net code. But If we know that the Values of a Single Row would not be the same, then We can make the first row of the Datatables as the Column Headers first. Then Remove the First row.

This way the Rows are Intact while the Header Names/Column Names are removed.

Take a Look at the below Implementation :

We get the First Row Values in the form of an Object Array.

drArray = DT.Rows(0).ItemArray.ToArray

drArray is a Variable of Type Array of Object.

Now we would require to Change the Column Names of the Datatable, which we can perform using For Each Activity as shown below :

Notice, I have also declared i as the index varaible of For Each.

Lastly We can remove the First Row from the Datatable using the Remove Data Row Activity in the below way :

But this method should only be used when there is certainty that we have different values in the First Row, Else while renaming the Columns there would be an Exception Generated.

We can tackle Problems like that too generally later if found.