Excel Append Range activity NOT working

Help Studio
, ,
1

Hi,
I am using Excel Append Range activity to append a DataTable to the first empty row in an Excel sheet. This DataTable only has one row.

BUT, instead of filling the first empty row (i.e. Row 2), it appends the DataTable to somewhere further down and letting alot of empty rows
It only game me correct results the first time i runned the workflow but then when re tried it again it keeps giving me the same problem
How can I fix this?

2

@kawtar.ettayarssouti

You can give the range where the Range has to start

Like A2

Hope this may help you

Thanks,
Srini

3

@kawtar.ettayarssouti

Also if you don’t know the Range you want to paste

Then you can use Read Range activity and declare a Datatable variable

Now you have to ensure that Add Header is enabled

Write as below to get the rows already there like

IntRows = DatatableVariable.Rows.Count

Now you can write in a Range like A + (IntRows + 1).ToString

+1 because the count starts from 0

Hope this may help you

Thanks,
Srini

4

I think this wont work for me since the workflow will be runned for serveral time and this might drop the previous results and copy the new ones

5

@kawtar.ettayarssouti

It will work, that’s why we are checking the Rows before and you are using the Append Range

So the Rows count will always not similar once you are adding the data

Hope this will help you

Thanks,
Srini

7

I have multiple columns