Why doesn't append range work?

Help Activities
,
1

Hi, i’m trying to add a Datatable to an existing sheet (empty but with headers). Why doesn’t it work ? it doesn’t do anything.

here is the workflow. the whole process is inside of an excel application scope activity. I blacked irrelevant information.

Uipath
Uipath572×711 22 KB

process:

  • Open File (Excel Application Scope)
  • Build a Datatable: dtBuild, data from same File but diffrent sheet.
  • append dtBuild to sheet “Log”
2

Hi,

I suppose first perhaps you should check content of datatable at Append Range activity.

Can you try the following steps?

  1. Set breakpoint at Append Range activity.
  2. Run “Debug”
  3. It will stop at append range, then check content of the datatable at Locals Panel.

If it has no data, you might need to review your logic.

Regards,

3

I checked the Data Table content, it’s not empty. The Data is complete but it isn’t saving it in the sheet

4

Wehen I delete the sheet “Log” sheet and run it again append range is working again. But it isn’t working when I only delete the data of the sheet.

5

Thank you for your help. I now know what the problem is… I’m running a Excel macro after append range. Apparently it is clearing the sheet after each time. i don’t know why, but atleast I know the cause know…

1 Like