I am writing an Excel output that is pretty large, about 70mb. I'm using a template file which seems to increase the writing time significantly. The file is getting written to the C: drive of the server, so its not being written to a mounted drive or a network drive. My issue is it seems to take about 30 minutes to write the file. Whereas if I write the data I need to a csv it will only take about a minute.
Is there any tips to make the excel node any quicker? Why is it taking so long? The template file itself is only 33kb, as all it is is colors on the header rows.
-------------------------------------------