Hello,
does anyone can provide an example of the parameters for Export SQL to Excel to generate a file with two or more sheets?
Thanks in advance.
Discussion posts and replies are publicly visible
Please find the attached screenshot for inputs:
Configure the below inputs in the first Export SQL to Excel node
Excel base template -Map the base template with multiple sheets (like SheetA,Sheet B) which was already uploaded in the folder.
SQL - Pass the sql query
Sheet Number = 0(for Sheet A)
Starting Cell -"A2"
Document name=Name of the document
JNDI Name=datasource name(jdbc/AppianBusinessDS)
Save the output of the node in a process variable of type document (pv!generatedDocument) and pass the document to the the next Export SQL to Excel
Inputs to the second node:
Excel base template -pv!generatedDocument
Sheet Number = 1(for Sheet B)
If you have multiple sheets in the excel, repeat the steps above.
Thanks!