Re: Excel and PL SQL
From: joel garry <joel-garry_at_home.com>
Date: Wed, 12 Nov 2014 13:27:30 -0800 (PST)
Message-ID: <dec33413-eb2f-4f57-b195-9e43a8683f56_at_googlegroups.com>
On Wednesday, November 12, 2014 6:27:45 AM UTC-8, colmkav wrote:
> Hi,
>
> Pls could someone tell me how using PL SQL, I can read data from Excel and also creating an excel file? For example I would like to save the output of my Oracle query to an excel file and then make some formatting changes in the Excel output eg making headings in bold.
>
> thanks
> Colm
Date: Wed, 12 Nov 2014 13:27:30 -0800 (PST)
Message-ID: <dec33413-eb2f-4f57-b195-9e43a8683f56_at_googlegroups.com>
On Wednesday, November 12, 2014 6:27:45 AM UTC-8, colmkav wrote:
> Hi,
>
> Pls could someone tell me how using PL SQL, I can read data from Excel and also creating an excel file? For example I would like to save the output of my Oracle query to an excel file and then make some formatting changes in the Excel output eg making headings in bold.
>
> thanks
> Colm
Also see http://www.orafaq.com/wiki/ODBC_FAQ#How_does_one_get_Oracle_data_into_MS-Excel.3F http://www.thatjeffsmith.com/archive/tag/excel/ http://hoopercharles.wordpress.com/2009/12/02/retrieve-data-to-excel-with-a-macro-using-ado/
jg
-- _at_home.com is bogus.Received on Wed Nov 12 2014 - 22:27:30 CET