Hello,
I wanted to create an Excel sheet with more than 50 columns, So I created 2 excel templates 1 with 50 columns and remaining columns in another template.
added them into 2 different export Data store entity to Excel nodes and used Merge Excel Documents node. I am able to Merge the 2 documents.
I set the starting Cell for 2nd excel node to "AY2" thinking the 2nd documents data would be displayed there. but, data of 2nd document is starting from the row where the 1st documents row ends.
Is there a way where I can get the 2nd documents data start from AY2?
TIA.
Discussion posts and replies are publicly visible
Dear Muneer Verma,
Smart Service "Merge Excel Documents" only work for merging two identical data sets. Don't support appending extra columns for the same set of data.
Hi Muneer Varma,
I think the below plug-in will be a good solution to export more than 50 columns-
community.appian.com/.../sql-to-excel