Create Multiple Excel sheet

Topics: Developer Forum, Project Management Forum, User Forum
Jan 26, 2012 at 10:08 AM
Edited Jan 26, 2012 at 10:10 AM

How can we generate multiple excel file from the one work sheet for different  values group.


$sql query= " SELECT * from company"

generate output ->

Com Name	Package Name
xx BPQ yy BPQ xx BPQ xx EP yy EP xx EP
xx FQ
yy FQ

How can I generate separate excel sheet for each package.
eg-: bbq.xls, EP.xls,Fq.xls

I appreciate any response.  Thank you!
Feb 1, 2012 at 8:09 PM

Do you want different files? or several worksheets within the same workbook file?

If the latter, then use the createSheet() or addSheet() methods to create each additional worksheet