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
  •  I am trying to create multiple sheet excel by  following above steps, but getting  error on mapping Excel_Base_Template 

    Error : "The  following error was raised by the Export to Excel function:  Cannot write data, document seems to have been closed already"

    Have you ever seen this error?

    can you provide some insight on how to resolve this

    Thanks

Reply Children
No Data