How to append the column values afetr the last column dynamically

Help Automation Ops
,
1

How to append the column after the last column and their values which are saved in a variable. How to append them after the count of columns.

2

Hi Priya,
Use a For Each Loop. Then using Write Cell activity, you can specify the sheet name and in the range specify the row Name with Index counter.
For Ex: A1 cell means A column 1 row. in place of first row, use Index and then assign index = index+1

In write cell, you can provide the variable name.

Let me know if it helps.

3

the columns are not fixed.How to append after the last column

4

@anjani_priya,

If you are trying this with Excel activities then use Read Range activity inside Excel Scope this will give you DataTable.

intLastColumn = dtExcel.Columns.Count+1

This will give you last column.

Use this code to get column letter.

strColLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(intLastColumn )

Column header cell

strCell = strColLetter +"1"

Rest data you can write by changing the row number as per your logic.

like strColLetter +"2" strColLetter +"3" etc.

Thanks,
Ashok :slight_smile:

5

I have used modern activities write cell

6

Select Custom Input for property Where to write and pass the last column range we prepared.

  • Where to write - Click Plus docs image on the right side of the field and then, from the menu, select an Excel file and a named cell where to enter the data, or select Indicate in Excel to indicate directly from the file. Alternatively, you can select Custom Input to enter a cell address manually, or Open in Advanced Editor to enter a VB expression.

Thanks,
Ashok :slight_smile:

7

rows are also not fixed

8

ok but there would be some logic right where you want to write the data. Implement the logic to identify which row needs to be updated and combine ColumnNumber + RowNumber and this would be your destination cell to write.

Thanks,
Ashok :slight_smile:

9

how to add this in write cell modern activity

10

Hi ,
->Read the DataTable
→ Use an Assign activity to get the column count.
image
→ Use the Add Data Column activity to add a new column.
->Use a loop to populate values into the new column.
image
CurrentRow.Item(columncount) = values to place

11

This is how you can do it.

image
image522×535 13.9 KB

Thanks,
Ashok :slight_smile:

12

how to get the strcolname and rownumber

13

Here I have explained the logic.

But if you want to enter at any other cell use this in where to write

Excel.Sheet("Sheet1").Cell("A4")

image

Thanks,
Ashok :slight_smile:

15

I didnt get the proper values

16

What values you didn’t get. What was expected and what is getting and what are the cell you are looking into?

17

Capture55
Capture551542×288 5.77 KB

in this, I have to get the values at j beside of quantity but I am getting the values beside of june23

18

Ok. What’s the logic you are using to retrieve it?

19

same as this

20

Hi @anjani_priya

You can try the below workflow for this,
Regex_Practice.xaml (41.2 KB)

Hope it helps!!

21

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.