Write range excel become empty

Im writing range to an excel worksheet in 4 rounds, each time different columns.
e.g. 1st round A1:GX100, 2nd round GY1:BG100, 3rd round BH1:BZ100, etc

But after the whole compilation. the final excel file is empty, except for the headers… Why does this happen?

Hi @Username95

Have you tried using a Breakpoint before the Write Range, to see if the variable is as expected? It seems like your variable is empty

1 Like


Before write range check the datatable is returning any data by placing output datatable activity and message box, In this way you can find the issue

Hope this helps you


Can you please try with ‘append range’ activity. It will append to existing data in datatable