Is there a feature that merge two excel files and then create one excel file?
There is no build in fonctionality to merge two excel files into one ,but i've made AE script that merge two csv files into one (see in attachement), a third party tool can convert the result.csv into xlsx.
File content and description :
VARA EXCEL : Static vara to stock the first csv file then the second
JOBS WINEXCELMER : windows job with the main script of binding the two csv files and writing the result.csv
PRPT EXCELMERGE: a prompset to store the first and second csv path file into varables &CSV1# and &CSV2#