Home » SQL & PL/SQL » SQL & PL/SQL » Format Excel using pl/sql (Oracle 10g)
Format Excel using pl/sql [message #343021] Mon, 25 August 2008 23:08 Go to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
Dear all,

I'm uploadeding data from oracle tables to excel sheet using utl_file. Is there is any possibilites of fomatting the excel sheet via pl/sql. I dig the net and found we can do via xml codes, but its very had to understand. can you pls tell me in simpler way.

Rgds,
DL
Re: Format Excel using pl/sql [message #343022 is a reply to message #343021] Mon, 25 August 2008 23:12 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

>can you pls tell me in simpler way.
Use the SEARCH capability on the forum.

Alternatively load Oracle client s/w on PC running EXCEL & use ODBC from Excel to pull data from Oracle.

[Updated on: Mon, 25 August 2008 23:15] by Moderator

Report message to a moderator

Re: Format Excel using pl/sql [message #343025 is a reply to message #343021] Mon, 25 August 2008 23:30 Go to previous messageGo to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
you are asking me to create macro?
1.I've no problems in generating the report or upload data from oracle into excel sheet.
2. Currently my backend procedure uploads the data in Excel master template (macro) where formatting is done there and then it is saved as different file and mailed to the users.
3. Now i need to maintain 2 files one is my backend procedure and another is master template.

4. Thats why i asked for help to format the excel sheet via backend procedure.

Attached is the similar program using xml. But since i have no idea on xml very tough to understand.

Pls help on this.

Rgds,
DL
Re: Format Excel using pl/sql [message #343028 is a reply to message #343021] Mon, 25 August 2008 23:43 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>you are asking me to create macro?
NO. From my perspective a "macro" operates against data existing within the spreadsheet.

Excel using ODBC can pull data from an RDBMS datasource such as Oracle.

GOOGLE is your friend, but only when you actually use it.

[Updated on: Mon, 25 August 2008 23:44] by Moderator

Report message to a moderator

Re: Format Excel using pl/sql [message #343033 is a reply to message #343021] Tue, 26 August 2008 00:04 Go to previous messageGo to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
>GOOGLE is your friend, but only when you actually use it.

I accept, thats how I find this forum. I posted here to get idea from the experts who might have experience this scenario.

Anyhow i got a solution by digging the net.

Attached is the sample...

Rgds,
DL
Re: Format Excel using pl/sql [message #343267 is a reply to message #343021] Tue, 26 August 2008 15:49 Go to previous message
coleing
Messages: 213
Registered: February 2008
Senior Member
This package is fantastic - it comes with examples.

Ive seen quite a few XML Spreadsheet generators, but this is my favourite so far..

Basically, it allows you to create an Excel 2003 + compliant XML Spreadsheet, with multiple sheets, formatting, conditional formatting, everything you could want.

You can even just throw a bunch of sql queries at it, and it will produce a multi-sheet Spreadsheet with the results. Over 65k rows over-flows to a new sheet automatically.

http://matzberger.de/oracle/spreadsheet-en.html

[Updated on: Tue, 26 August 2008 15:50]

Report message to a moderator

Previous Topic: Reg accessing one user's object from other users with read only option
Next Topic: Error in case function?
Goto Forum:
  


Current Time: Thu Dec 08 16:41:52 CST 2016

Total time taken to generate the page: 0.16135 seconds