https://community.qlik.com/t5/Talend-Studio/How-to-write-data-in-1-excel-file-with-multiple-excel-sheet/m-p/2349319#M116318 Hi <BR />It is impossible to split the data to different sheet on tFileOutputExcel, a workaround is to split the data to several files with tFileOutputDelimited first, and then, use a tFileList to iterate each delimited file and append them to the same file with different sheetl, the job looks like: <BR />tFileInputDelimited--main--tFileOutputDelimited <BR />&nbsp; &nbsp;| <BR />onsubjobok <BR />&nbsp; &nbsp;| <BR />tFileList--iterate--tFileInputDelimited--main--tFileOutputExcel <BR /> <BR />on tFileOutputDelimited, check the 'Split output in several files' box and input the number of rows in each file.&nbsp; <BR /> <BR />on tFileOutputExcel, write a dynamic sheet name, eg: <BR />((String)globalMap.get("tFileList_1_CURRENT_FILE")) <BR /> <BR />and check 'Append existing file' box.&nbsp; <BR /> <BR />Regards <BR />Shong Tue, 15 Mar 2016 05:20:12 GMT Anonymous 2016-03-15T05:20:12Z https://community.qlik.com/t5/Talend-Studio/How-to-write-data-in-1-excel-file-with-multiple-excel-sheet/m-p/2349318#M116317 <P>Hello!<BR />I have problem in adding data in excel file.<BR />My data list consist of 65k + data and it can't be added in excel file. I need to split them in 30k data in different excel sheet but in same excel file.<BR />Anyone knows how to do it?<BR /><BR />TIA - cagedbird</P> Tue, 15 Mar 2016 02:13:25 GMT https://community.qlik.com/t5/Talend-Studio/How-to-write-data-in-1-excel-file-with-multiple-excel-sheet/m-p/2349318#M116317 _AnonymousUser 2016-03-15T02:13:25Z https://community.qlik.com/t5/Talend-Studio/How-to-write-data-in-1-excel-file-with-multiple-excel-sheet/m-p/2349319#M116318 Hi <BR />It is impossible to split the data to different sheet on tFileOutputExcel, a workaround is to split the data to several files with tFileOutputDelimited first, and then, use a tFileList to iterate each delimited file and append them to the same file with different sheetl, the job looks like: <BR />tFileInputDelimited--main--tFileOutputDelimited <BR />&nbsp; &nbsp;| <BR />onsubjobok <BR />&nbsp; &nbsp;| <BR />tFileList--iterate--tFileInputDelimited--main--tFileOutputExcel <BR /> <BR />on tFileOutputDelimited, check the 'Split output in several files' box and input the number of rows in each file.&nbsp; <BR /> <BR />on tFileOutputExcel, write a dynamic sheet name, eg: <BR />((String)globalMap.get("tFileList_1_CURRENT_FILE")) <BR /> <BR />and check 'Append existing file' box.&nbsp; <BR /> <BR />Regards <BR />Shong Tue, 15 Mar 2016 05:20:12 GMT https://community.qlik.com/t5/Talend-Studio/How-to-write-data-in-1-excel-file-with-multiple-excel-sheet/m-p/2349319#M116318 Anonymous 2016-03-15T05:20:12Z