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
main xls will contain 5 different sheets
this 5 files are of different format
Please help on this..
Last edited by amit2676 (2017-02-07 09:57:36)
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)