Write cell last row excel

Help
, ,
1

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

image
image1600×868 76.1 KB

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

1 Like
2

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!

3

I get this error when I try what you mention could you help me?

image
image1339×452 24.4 KB

1 Like
4

@Ivan_torres_oliva

Here, you are assigning DataTable rows count to DataTable variable and that’s why you are getting that error.

     Int rowCount = PLANTILLA.Rows.Count
5

I could correct that but I can’t write after the last cell with data

Main.xaml (6.8 KB)

this is my workflow

6

You should use “filas” variable into write range
for last cell you should take
(PLANTILLA.Rows.Count+1).ToString

"C" + filas

7

I tried what you mentioned but I get the following error in read range

image
image1592×737 58 KB

Main.xaml (9.1 KB)

8

You want to read that excel fro C1?
give that cell no not only C

9

OCRtest2.xaml (12.6 KB) OCRtest2.xlsx (7.1 KB)

I have problem too. I have attached to easiest understand.
Please suggest me.

10

Hi @Ivan_torres_oliva in the read range activity remove “C” and keep it blank.

1 Like
11

i tried to remove it but not work.

1 Like
12

will you share the sample of your workflow and files

1 Like
13

sure above i have shared alredy

14

In read range
Please give range like, “B1”

15

Hi,

I am having the same issue as @nypaan10.

Do you know how can we fix it?

Thanks! :slight_smile:

16

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

17

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 :slight_smile:

1 Like