Creating multiple Excel worksheets within the same workbook.
615711Jul 22 2009 — edited Jul 23 2009This may seem basic to you gurus but I'm fairly new to PL SQL.
I have a package that runs three select statements and then writes the output to a tab delimited file. These run one at a time and are self contained as far as first writing a header to the file, then creating, opening and writing from a cursor to the file for each procedure. The user then double clicks on the file and it opens up in Excel. The problem is that the data from the three select stmts are all in one sheet. I would like to have each procedure create and write to it's own sheet within the same workbook.
I have spent many hours researching this on the net and have found some very complex solutions from people like Jason Bennett and others. All I need to know is what to add to each of my three procedures to create a new sheet within the workbook. I'm sure it is just a line or two but I cannot figure it out. I'm currently using UTL_FILE.PUT_LINE to write the data.
Thanks for your help.
Randy