Keep Write Range headers consistent when defining DataColumn.Expression

[msan (Michel SAN)]

Hi,

When you use UiPath.Excel.Activities.WriteRange activity with AddHeaders checked, the headers are not those in OutputDataTable produced string when you set a DataColumn.Expression propertie.

Could you please make the headers produced by WriteRange the same are those produced by OutputDataTable? If I had to chose, I’ll pick DataColumn.Caption property as header.

You’ll find an example as attachment. You’ll need UiPath.Excel.Activities to run it.

WriteRangeHeader.xaml (7.7 KB)

Here is a post mentionning the issue

How to concatenate two columns in datatable without looping and keep concatinated data in new column?

Hi @VasuNaidu I used this method and everything is working fine but expression also added in the formula column name which only “Formula” name supposed to display. Concatenating 2 columns A and B and saving it in Formula but it appears Formula+A+B How to make sure only the column name “Formula” appears This is Target Object = dt.columns.add(“Formula”, GetType(String), “[A]+[B]”) Passing 2 as in argument for SetOrdinal method

[Pablito (Pawel Wozniak)]

Hi,
Thank you for your suggestion. I added it to our internal ideas tracker for our team to consider.