I have an excel and I want to write a range after the last cell with data, I just don’t know how to do it, someone will have some example to help me
That is my excel where I want to write in this case in column “C” I want to write after the last cell with data, as it will increase the data I will always have to get the last cell and then write
hey @Ivan_torres_oliva
you can use the “append range” activity, or get the last row from you data tabla ever before write using the YourDataVariable.Rows.Count. and after having the last cell then write.
Regards!
Here, you are assigning DataTable rows count to DataTable variable and that’s why you are getting that error.
Int rowCount = PLANTILLA.Rows.Count
I could correct that but I can’t write after the last cell with data
Main.xaml (6.8 KB)
this is my workflow
You should use “filas” variable into write range
for last cell you should take
(PLANTILLA.Rows.Count+1).ToString
"C" + filas
You want to read that excel fro C1?
give that cell no not only C
OCRtest2.xaml (12.6 KB) OCRtest2.xlsx (7.1 KB)
I have problem too. I have attached to easiest understand.
Please suggest me.
Hi @Ivan_torres_oliva in the read range activity remove “C” and keep it blank.
i tried to remove it but not work.
will you share the sample of your workflow and files
sure above i have shared alredy
In read range
Please give range like, “B1”
Hi @Angel_Llull
In the below video, you can able to know that how to get the last row and last column.
When you concatenate both, you can get the last cell.
Thank you
Balamurugan.S
Hello @balupad14,
Thanks for the video!
What I would need it to write after the last filled excel. I mean, for each line in DT, write after the last filled cell. I have, for example, 10 writen rows and in DT I have 5 rows, so the first row of DT write in 11 row, second row in DT write in 12 row, and so on.
Do you know how can I do it?
Many thanks 
