Extract data into Excel and enable macros from PL/SQL procedure

dr3586

Hi,

I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?

For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.

However I am trying to automate the manual process. Any suggestions or direction?

Thanks,
DR

singhnitin

Quote:

Originally Posted by dr3586

Hi,

I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?

For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.

However I am trying to automate the manual process. Any suggestions or direction?

Thanks,
DR

hI
Can you please send me that pl/sql procedure that extracts data into an excel worksheet.
As i am working on a similar case
Email id: [ Removed ]
Thanks alot
Nitin Singh

amitpatel66

Quote:

Originally Posted by dr3586

Hi,

I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?

For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.

However I am trying to automate the manual process. Any suggestions or direction?

Thanks,
DR

Setting a macro would not be possible from PLSQL.
Could you please tell what is that macro going to do?

One suggestion would be to connect to oracle database from Excel using macro and fetch the data in to excel sheet.

debasisdas

You can't set macros form PL / SQL.

jdhtoo

Hi, I have the same request. I am collecting data via PL/SQL procedure and downloading them in excel. I have a macro that runs a chart. I am trying to make the whole report automated. Any other workaround for the macro to run?
Thanks.

amitpatel66

Quote:

Originally Posted by jdhtoo

Hi, I have the same request. I am collecting data via PL/SQL procedure and downloading them in excel. I have a macro that runs a chart. I am trying to make the whole report automated. Any other workaround for the macro to run?
Thanks.

I hope you would have got the answer from the above posts that setting a macro using PLSQL is not possible.
You can rather connect to oracle DB from excel using macro and fetch the data and store them in the oracle work book.

praise

hi...
i would like to know about the procedure that u used to extract data into excel.

Quote:

Originally Posted by dr3586

Hi,

I have an Oracle PL/SQL procedure that extracts data into an excel worksheet. I am wondering if there is anyway from the procedure to also set the macros of the excel document that is created?

For example, usually the macros are manually done:
Go to Tools, Macros – Macro. Select the “Automate” macro and click “run”.

However I am trying to automate the manual process. Any suggestions or direction?

Thanks,
DR

SOMIYA

Can some please put up the Stored proc to load data from a table into excel file?

asp2

you can "run" a macro using client-side client_ole2 code , use:

args:=client_ole2.CREATE_ARGLIST;
client_ole2.ADD_ARG( args, V_MACRO_NAME );
client_ole2.INVOKE( Application, 'RUN' ,ARGS );
client_ole2.destroy_arglist(args);

billhockeydude

Hey,

We are really happy with this tool called Excellant. It allows you in pl/sql to create clobs of excel using xml and sql. It does styles, formulas and multi sheet. Not sure about macros. The website is http://www.peak42solutions.com. We started using them a few weeks ago it rocks.

Bill

Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

re: Extract data into Excel and enable macros from PL/SQL procedure

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about