Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating multiple Excel worksheets within the same workbook.

615711Jul 22 2009 — edited Jul 23 2009
This 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2009
Added on Jul 22 2009
4 comments
1,303 views