I wanted to simply copy just headers from one excel to another - I tried it with:
- Invoke method
- copying the whole table and then deleting every single row except of the headers (with Remove Data Row Activity and it does not seem to work. - always getting the empty excel sheet
- creating headers manually (with Build Datatable) and again when I want to put it inside the other excel sheet - I get the empty sheet (Just in A1 cell is written: “Column 1”)
Important: When I use Activity: Output datatable (just to print my datatable to see whether I have good values and whether my table is empty)-> I actually get the right values (my headers). But then again in excel - nothing…
I am desparate, does anyone have solution for this?