How to remove unwanted header in excel

[supermanPunch (Arpan)]

@ppr

if the auto generated names are used

• then: use first row for column name renaming and remove afterwards the first row e.g. with LINQ or Remove DataRow Activity

Hi @Raja.G ,

As already suggested by @ppr , If you need to rename the columns in a Datatable itself then we can go ahead with Renaming the columns using the First Row values. A More descriptive step is mentioned in the below post :

How to paste datatable in word without Column0, Column1

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…

Also, Do Check on the retrieval stage itself whether we get the Column Names as it is required.

Let us know what you have tried and it’s outputs.