How to write data in 1 excel file with multiple excel sheet
Hello! I have problem in adding data in excel file. 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. Anyone knows how to do it?
Hi
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:
tFileInputDelimited--main--tFileOutputDelimited
|
onsubjobok
|
tFileList--iterate--tFileInputDelimited--main--tFileOutputExcel
on tFileOutputDelimited, check the 'Split output in several files' box and input the number of rows in each file.
on tFileOutputExcel, write a dynamic sheet name, eg:
((String)globalMap.get("tFileList_1_CURRENT_FILE"))
