Line Breaks Handling in Excel Column Headers (Column Name is in multiple lines in cell)

Help Activities
,
2

Hi @Irfan_Musa

Here is a solution to change the Column Names of a data table by removing nextline characters:

The Process Flow:

  1. Use a For Each Activity.
  2. Under the In property: dt_Data.Columns. This will make the Item set to currentDataColumn automatically.
    The image shows a workflow in UiPath where data is read from an Excel file named "Data.xlsx" in "Sheet1" and iterated through each data column to assign values. (Captioned by AI)
    The image shows a workflow in UiPath where data is read from an Excel file named "Data.xlsx" in "Sheet1" and iterated through each data column to assign values. (Captioned by AI)568×430 11.1 KB

    The image displays the properties pane for the UiPath 'For Each' activity configured to iterate over DataColumns, with the item name 'currentDataColumn' and the index 'CurrentIndex'. (Captioned by AI)
    The image displays the properties pane for the UiPath 'For Each' activity configured to iterate over DataColumns, with the item name 'currentDataColumn' and the index 'CurrentIndex'. (Captioned by AI)676×337 6.5 KB
  3. Use an Assign Activity with the following Code:
currentDataColumn.ColumnName = currentDataColumn.ColumnName.Replace(Environment.NewLine, " ").Replace(vbCrLf, " ").Replace(vbLf, " ")

The Output:
As you can see in the below screenshot from the Immediate panel. The dt_Data before and after the for each/

image
image442×202 3.13 KB

If this solves your issue, Do mark it as a solution.
Happy Automation :star_struck: