Hi there,
I am using Render tool to create the final output excel file(.xlsx). The final output excel file is consisting of 4 excel sheets inside of it namely: "1. ABC" , "2. DEF" , "3. KLMN" , "4. XYZ".
The excel sheet "2.DEF" is having 171000 rows of data due to which render tool is giving "out of memory error". For resolving this error, I have split the workflow into 2 parts i.e. one part of the workflow is producing the final output excel file(.xlsx) by including "1. ABC" ,"3. KLMN" , "4. XYZ" sheets only and the another part of the workflow producing the final output excel file(.xlsx) by including "2. DEF" sheet only.
So now Render tool is overwriting the sheets i.e. if I am running the 1st part of the workflow, then followed by 2nd part of the workflow so only "2. DEF" sheet can be seen in the final output excel file(.xlsx). Do we have any ways to prevent overwriting of the sheets or file in Render Tool?
Apart from this, I have tried another approach in which I am using Render tool in the first part of the workflow which is producing the final output excel file(.xlsx) which includes "1. ABC" ,"3. KLMN" , "4. XYZ" sheets only. And in the second part of the workflow which is producing the final output excel file(.xlsx) by including "2. DEF" sheet only, I am using output tool for the creating a new sheet in "2. DEF" sheet in the output excel file(.xlsx) which includes "1. ABC" ,"3. KLMN" , "4. XYZ" sheets generated by 1st part of the workflow using Render tool. But the issue is that sometimes final output excel file (.xlsx) is getting corrupted. On opening the file, excel prompts a file recovery message.
Could anyone please help, as I am stuck with this issue .
