Data table columns

[A_Learner]

Greetings!
I am reading an Excel sheet into a data table dt1 which has column Names and data rows.

Trying to get data at cell B2. I could read cell B2. I am also trying to do dt1.Rows(0)(columnName). But the column Names have spaces. How do I remove space in the column name?

Thank you,

[Harshith_Adyanthaya]

Hi @A_Learner ,

Try this.

dt1.columns(0).ColumnName = dt1.columns(0).ColumnName,Replace(" “,”")

where 0 is a first column index.

If you want to do for all then,

Pull a for each and perform the following.

Hope it helps.

[A_Learner]

Thank you!