Write number at end of culumn

[Juandix (Juan Diego Reyes)]

Hey guys its me again
I want to write a value at the end of a column, the number of row of the data is different from files, so I want to make the robot always write it at the end
This is how I get the value of each row

[Anil_G (Anil Gorthi)]

HI @Juandix

try this in assign

Currentrow(“Your column”) = Currentrow(“Your column”).Tostring + “Any value you want to add”

Ideally its better to read whole data into Datatable and then perform manipulations and write back

cheers

[Juandix (Juan Diego Reyes)]

So this will write the number at the end of the column this is how my excel file looks

I want to write the info in column B row 11 but the size of the table changes everytime

[Anil_G (Anil Gorthi)]

@Juandix

looks

Hi @Juandix

You want to write something at end of row or cloumn?

Can you show how the output looks so that it is more clear

cheers

[Juandix (Juan Diego Reyes)]

Sorry for the confusion i mean at the end of the row i dont have anything in the output just the sum of the numbers in the collum b

[Anil_G (Anil Gorthi)]

Hi @Juandix

Ok no problem

So first read the data into datatable (dt) using the read range activity with headers property checked

Then use a write cell and give the cell value as follows for writing in B column at the end

“B” + (dt.rowcount+2).tostring

Basically its counting thw rows and adding 2 as there is one header at the top and we need to write in next line

Cheers

[Juandix (Juan Diego Reyes)]

I have this error

[Juandix (Juan Diego Reyes)]

This is how I understood your solution

[RajKumar_DC (RajKumar Durai)]

Hi @Juandix,

What about below

Col1 = YourColumnName

dt.AsEnumerable.Sum(Function (x) If(Double.TryParse(x.item(“Col1”).ToString, 0), Double.Parse(x.Item(“Col1”).ToString), 0)).ToString

Xaml
Sequence11.xaml (9.2 KB)

Range = “B”+(dt.RowCount+2).ToString

Best,
Rajkumar

[Anil_G (Anil Gorthi)]

@Anil_G

“B” + (dt.rowcount+2).tostring

Hi @Juandix

To be exact this is what you need to write

Excel.Sheet("Prueba").Cell("B" + (dt.rowcount+2).tostring)

Please make sure to replace inverted comma if you are copy pasting it

Hope this helps

cheers

[Anil_G (Anil Gorthi)]

Hi @Juandix

If this is fixed can you please mark the solution and close so that it helps others as well

If not happy to help

Cheers