I have an excel template sheet with table borders and some embedded formulae. When I output the results of my dataflow using the Output excel node, all the template formatting is preserved and I get correct output.
But when I use the 'Append Excel' node to re-populate the fields in the template the formatting goes wrong, table borders and margins go away along with there is no alignment present.
Please let me know if I am doing anything wrong or is there some other issue. Please find snapshots of excel and append node output for your review.
Append Node Output
Excel Node Output
Please sign in to leave a comment.