i need to generate 2 tabs in excel sheet, for that i tried using 1st smart node as export sql to excel and generated 1st tab and used generated document as input for 2nd smart node - export sql to excel and used sheet no as 1, but it is giving the error - The following error was raised by the Export to Excel function: Sheet index (1) is out of range (0..0),
please let me know how we can resolve this issue or any other solutions available
Discussion posts and replies are publicly visible
Lokesh KothariHey! I was having the same issue, but I'm using Export CDT to Excel. It looks like you have to create all the sheets needed in the template beforehand, but the number of sheets is dynamic for me. Were you able to find a solution to this? Thanks!
Regards,
Also to note, in my experience the first sheet of the Excel document will be 0, not 1.