WriteRange

Help Studio
, ,
1

Hi,
If the output Excel already exists, does writerange datatable overwrite the Excel or append to exisiting data? Specifically do I see old data after I do writerange datatable?

Thank you,

3

@A_Learner

Write Range workbook overwrites the existing data. If you want to append use Append range workbook activity

Regards,

4

write range overides the data starting on the configured Range
Keep in mind:

  • when old data exists (e.g. 10 rows)
  • write range new data is less (e.g. 7 rows)
  • Then: row 8,9,10 from old data will not be deleted
5

Hi @A_Learner

Write Range basically overwrites the excel. But if you have less numbers of rows present in datatable than the rows present in the excel, then it will overwrite till wherever it wants after that the remaining rows are left unchanged.

Regards

1 Like
6

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