Append Range is Overwritting

Help
1

Hi There!

Is anybody facing a issue with Append Range activity?

I am trying to append range in a excel file without using excel scope because is think the other one is a bit faster … but it is not working … is overwriting …

I can try to find a workaround … just wondering if it is a bug … I am working with the enterprise trial version.

2

@carmen

It won’t. Could you please share the steps you followed to do this.

3

Append Range add the Information at the end of Sheet if it exists. Make sure if usedRange in your sheet is Correct before append

4

is everything ok … just I am retesting this only workflow … and alone is working ok … probably is another issue …

1 Like
5

Hi Carmen,

Does your data table have the same columns as your excel file?
To get the data table columns use a function called “Clone”

dtClone=[ExcelDatatable].Clone - this will fetch the schema and constraints of your existing data table, excluding your datarows.

One workaround is read the excel file, Once you got the data sets try to merge it using Merge data table activity then just overwrite your excel file.

Best Regards,
Jeven

6

yes! Thank you. My problem was actually other thing

7

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