How to merge 5 xls files into one excel file in different sheets

[Anonymous]

Dear Shong/users,

i have 5 xls files at a particular location on server, i want to send this 5 xls into one main excel file in different sheets
ex:-
main xls will contain 5 different sheets  
file1xls,file2.xls, file3.xls,file4.xls,file5.xls

this 5 files are of different format

Please help on this..
Thanks

[Anonymous]

Hi, 

try 


tFilelist --------iterate------ tFileinputExel ---------tMap------tFileOutputExcel

[Anonymous]

In the component tFileOutputExcel, just dynamize the sheet_name with for example the ((String)globalMap.get("tFileList_1_CURRENT_FILE")) and check "add to existing file"

[Anonymous]

Dears,
I resolved it using thashoutput and then using thashinput
Regards
Amit