How can I append data in xlsx file instead of overwritten?
For this, we need to use “Microsoft Excel Writer” step. Following are the configuration you need to do:
“File & sheet” tab:
- Select “Use existing file for writing” in “If output file exists” property.
- Select “write to existing sheet” in "If sheet exists in output file
- Select the check the box of "Start writing at end of sheet (appending lines).