I have two excel outputs from the same workflow, which have the same column structure but I want to append them in one file. Is there any way to do this? (I checked the append and overwrite options in excel writer but I encountered the following issues:
a) Either one file would completely overwrite the other
b) It would fail to add/append the data in the same file
Any input would be greatly appreciated!