Excel Copy

Help Studio
, ,
1

I have two excel,

->I read data from excel 1 and paste the info into excel 2 from the last row of excel2 , Problem is this is already has data like this

image
image1369×90 3.19 KB

I want data copied from excel one to start from this 1313 row(eg), i.e last row WITH column B.

I got the data using read range and write range till row 1313 , but how to get it in our required column?

2

@Rahul_Srinivas

Multiple ways

  1. Try using append range
  2. Read the data from second excel and use dt.Rowcount to know the number of rows and use read range with cell as "B" + (dt.Rowcount+1).ToString - assuming data or headers start from A1 else ass the number accordingly instead of 1
  3. In modern excel ypu can use Excel.Sheet("SheetName").Rowcount to get the number of rows

Try any of these

Hope this helps

Cheers

3

I tried append range but it says

Append Range: Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again.

I wonder it is because data is in a table ? Can you help

image
image1305×101 1.22 KB

4

@Rahul_Srinivas

Is that a table?

And are you using modern append range?

Modern append range can append to a table as well…you can provide the tablename

Cheers

5

It is a table…

No Classic activites…

6

@Rahul_Srinivas

Then try the second approach only to read and then write range eith count

Cheers