How Do I Remove the Spcae From the Datatable Cloumn header?

[kishan.savaliya]

Hello

I have One Excel File That Contains the Multiple Columns and Sometimes It Also Contains The WhiteSpace at the End of the String that I want To Remove And Want Plain Text Header.
Attached SS

[Gangadhar_Athili]

Read Sheet Without Headers (DT)

DT.Asenumerable.First().itemarray.Select(function(v) v.Trim).Toarray

Now Take For Each inside that
Assign
DT.Columns(idx).ColumnName=item

put idx variable in For each output

at the end write the data into excel without add headers.

[Sanjit_Pal]

Hey @kishan.savaliya,

You can do it using the below method.

Thanks,
Sanjit

[kishan.savaliya]

Thanks @Sanjit_Pal @Gangadhar_Athili For Solution