I’ve built a workflow that outputs 8 different tables. I’d like them to all be joined up as different worksheets in the same Excel file. Right now, I’ve just created a chain of Excel Sheet Appender nodes. As it progresses, each successive node takes longer to finish, even if the data tables for that specific node are not very big (sometimes taking 10 minutes per node). It seems that reading the Excel file is causing major memory issues. I have even started to get a “java heap space” error now as well.
The previous solutions I’ve seen on the forum only talk about removing the “autosize columns” feature and increasing the usage of ram and cells in memory. Are there any other solutions to creating an Excel file with multiple sheets that are not so resource intensive?