| Format Excel using pl/sql [message #343021] |
Mon, 25 August 2008 23:08  |
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 #343025 is a reply to message #343021] |
Mon, 25 August 2008 23:30  |
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 |
 |
BlackSwan
Messages: 26766
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 |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
