Excel tools export sql to excel multiple sheets

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

Parents
  • +1
    Certified Lead Developer

    Hi Martin Camacho (martind465) ,

    1. Prepare the template of excel sheet to generate.
    2. For the node excel from sql, pass sheet number as 0, template and other required parameters and capture the generated document in node output as append the generated document to pv of Document list.
    3. for the next sheet on wards, re execute the same node by incrementing the sheet number and generated document in prev execution of node as template.
    4. Delete the docuemnts i.e., pv of document list
Reply
  • +1
    Certified Lead Developer

    Hi Martin Camacho (martind465) ,

    1. Prepare the template of excel sheet to generate.
    2. For the node excel from sql, pass sheet number as 0, template and other required parameters and capture the generated document in node output as append the generated document to pv of Document list.
    3. for the next sheet on wards, re execute the same node by incrementing the sheet number and generated document in prev execution of node as template.
    4. Delete the docuemnts i.e., pv of document list
Children