We are using the Output Excel Node using the TemplateInputFile Parameter to write our Excel output to a template. The template has 57 columns some of which are "grouped" together. There is no other data in the file.
To write a few million records across a couple of these files is taking 2 hours. Any suggestions on how to improve performance? It should take a few mins. I saw in the help it mentions about not making the template contain too much data as the node could run out of memory but there is no data in the file except for column headings. Is there a limit on memory available to any one node?
Please sign in to leave a comment.