Home » SQL & PL/SQL » SQL & PL/SQL » Creating different worksheets in a single excel (Oracle 11g)
Creating different worksheets in a single excel [message #654215] Thu, 28 July 2016 06:18 Go to next message
venkat111
Messages: 4
Registered: July 2016
Location: Hyderabad
Junior Member
Hi,

I have one urgent requirement, please help us:


We are generating one report in ORACLE by using UTL_FILE package that is fine. But we nee to create different workheets in a single excel file.

1. Version: Oracle 11g
2. Generating file in using PL/SQl PROCEDURE
3. This PROCEDURE using in Oracle it self, there is no any JAVA call nothing.

EX:
Our query will give:
1
2
3
4
5
6

we need data in one excel like below:

Sheet1
1
2
3
Sheet2
4
5
6

Please help us and add sample code.
Re: Creating different worksheets in a single excel [message #654218 is a reply to message #654215] Thu, 28 July 2016 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 67951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to first know what is an multi-sheet Excel file format is.
And this is NOT an Oracle question.
Post here the Excel file format specification and we will help you to write the code.

Urgent answer is required as urgent as is the question for you.

Re: Creating different worksheets in a single excel [message #654255 is a reply to message #654218] Thu, 28 July 2016 14:15 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Check out the package at www.oraexcel.com that can do exactly what you want. It works in oracle 10 and above and generates true Excel spreadsheets instead of csv files. Also it is fairly inexpensive and within the reach of any company or individual.

[Updated on: Thu, 28 July 2016 14:15]

Report message to a moderator

Previous Topic: Extract value from xml
Next Topic: Database vs Tablespace
Goto Forum:
  


Current Time: Mon Sep 27 07:13:46 CDT 2021