Create Multiple Sheet from Excel Template - BI Publisher
Dear Experts,
I am creating a report and I need the output in multiple excel sheet based on certain data groups.
Currently i am creating it using RTF template and split-by-page-break.This gives a nice output in PDF though.
But in excel it has no effect. Is there any way i can create dynamic multiple sheet from excel template based on certain condition (e.g. split all the employee list by department where each department is represented in 1 excel sheet? so if there are two departments in company A, then excel output will have two sheets. If there are three departments in company B, then the excel output will have three sheets)