You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-02-07 09:20:05

amit2676
Member
107 posts

amit2676 said:

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

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

Last edited by amit2676 (2017-02-07 09:57:36)

Offline

#2 2017-02-07 12:05:36

kayim
Member
4 posts

kayim said:

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

Hi, 

try 


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

Offline

#3 2017-02-07 12:07:18

kayim
Member
4 posts

kayim said:

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

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"

Last edited by kayim (2017-02-07 12:16:29)

Offline

#4 2017-02-07 12:14:03

amit2676
Member
107 posts

amit2676 said:

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

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy