Write range excel activity doesn't add headers of a Blank Datatable

Help
21

Yes, did it long time ago… Thanks a lot for your response.

22

Hello @Anil_choudhary,
I have found a solution for writing Headers without any data in it.

Steps:

  1. Build DataTable with column names.
  2. Use Add Data Row with the first column as empty String.
    Eg. If you have two columns do this in ArrayRow Property:- {“”}
  3. Use Write Range
  4. Now use Clear Data Table
  5. Again use Add Data Row for your data
  6. And Finally, Use Append Range.
    img
    img841×488 11.7 KB
6 Likes