please help me.
i need to merge all excel files into one excel file one row after the other. all the source xls are available in one path..
Please see the document for your reference on how to combine multiple sheets into a single sheet (one row after another), it will help you to achieve your requirements:
(Note: you may modify (add/update lines) the Code Example accordingly for your needs)