Add 3 columns based on on existing columns

[ManjunathReddy (P Manjunatha)]

Input Excel

DATA1.xlsx (10.1 KB)

the Output which I am expecting

Thanks in Advance.

[Anil_G (Anil Gorthi)]

@ManjunathReddy

May I know what you mean based on existing?

the column names would be same? would you need to add 3 columns for previous date always?

if yes then build a datatable with 3 columns…then add datarow with array row as {Now.Adddays(-1).ToString("dd-MM-yy"),Now.Adddays(-1).ToString("dd-MM-yy"),Now.Adddays(-1).ToString("dd-MM-yy")}

then one more with required bank details

now use write range to write the data…and to get what is last column…you can first read the data usign read range then perform dt.Columns.Count which gives you the number of columns already present

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(dt.Columns.Count+1) gives the column name

Hope this helps

cheers

[ManjunathReddy (P Manjunatha)]

is build a data table have blank column names?

Then using add data row adding the columns right?

[Anil_G (Anil Gorthi)]

@ManjunathReddy

Give any 3 column names no need to add columns…add datarow…and when you write uncheck header options…so only data is written

ideally yes in add datarow we are adding both the top two column names we need

cheers

[ManjunathReddy (P Manjunatha)]

Here Build data table & read range data table both are same or different?

[Anil_G (Anil Gorthi)]

@ManjunathReddy

Read range is to find out how many columns are already present

Build datatable is to create a new datatable with 3 columsn to add at the end of current columns

Cheers

[ManjunathReddy (P Manjunatha)]

Can you please look into.

Thanks

[supermanPunch (Arpan)]

Hi @ManjunathReddy ,

Could you also provide us with the Expression used in the Range property ?

Also, If possible provide also the contents of the dt_Column datatable.

[ManjunathReddy (P Manjunatha)]

Range Property Code : UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1)

For more clarification referrer the top post

[supermanPunch (Arpan)]

@ManjunathReddy

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1)

@ManjunathReddy ,

The above expression alone is not sufficient, You should also add the Index or row number to it.

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1)+"1"

[ManjunathReddy (P Manjunatha)]

Didn’t get expected output.

@Anil_G

[supermanPunch (Arpan)]

@ManjunathReddy

Didn’t get expected output.

@supermanPunch

Also, If possible provide also the contents of the dt_Column datatable.

@ManjunathReddy ,

So now, we do not have the Error in place, but the Output is wrong.

So we ask again what is the content in the dt_Column.

[ManjunathReddy (P Manjunatha)]

I just created the datatable to add the dates into it .

[supermanPunch (Arpan)]

@ManjunathReddy ,

Apologies.

I believe @Anil_G has already mentioned the method in the previous post. Could you refer it ?

@Anil_G

if yes then build a datatable with 3 columns…then add datarow with array row as {Now.Adddays(-1).ToString("dd-MM-yy"),Now.Adddays(-1).ToString("dd-MM-yy"),Now.Adddays(-1).ToString("dd-MM-yy")}

then one more with required bank details

now use write range to write the data…and to get what is last column…you can first read the data usign read range then perform dt.Columns.Count which gives you the number of columns already present

So, when using Write Range activity, Uncheck Add Headers option. It should be the desired output.

[Anil_G (Anil Gorthi)]

@ManjunathReddy

Two add data rows are needed and in write range remove headers check box

As per output i can see you did not add banks related add data row

Also did not uncheck headers in write range

Cheers