How to append in 'Write Range Workbook' activity?

image

Like in the following ;

image

Hi @170290064

Use Append range workbook activity to append

image

Hope it helps!!

Hi @170290064

If you want to append the data please use Append Range activity
image

1 Like

Hi,

Thank you

1 Like

after the write range you mean ??

image

@170290064

By using excel activities only it is available Append
By using work book activities use Append Range Work Book Activity

Hi,

You can use the append range activity it easily append the data .

Thank you

So should i use only Append Range Workbook?

Hi @170290064

You can use the write datatable to excel activity but this activity has to closed with excel process scope and use excel file activity. If you check the append option it will append to the old datatable.

If you want to add datatable by using workbook activities, use the append range workbook activity.

Hope it helps!!

1 Like

@170290064
Instead of Write range you can directly add append range activity

Hope it helps!!

@170290064
Instead of write range use Append Range activity to add data

Hi,

You can use the append range activity there is no need of write range.

Thank you

Can i add headers by using ‘Append Range Activity’ :thinking:

@170290064

Hi,

In append range activity theres no property of Header while in the write range it has propertie of Add Headers

Thank you

@170290064

There is no options to add headers in append range activity.
You can use either write range and append or
Builld datatable with column names and use append range activity to add

Hope it helps!!

1 Like

@170290064

First use write range activity then use Append Range activity to append the data to it.
Otherwise, Build a data table with columns then use append range workbook activity

Thanks for all answers :slightly_smiling_face:

@pravallikapaluri
@rlgandu
@mkankatala
@lrtetala

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.