Run Excel Macro from Java

D

Darshit Rao

I want to run the macro present inside the excel sheet using the Java
code. Is is possible using Java code? Please help
 
A

Ann

Darshit Rao said:
I want to run the macro present inside the excel sheet using the Java
code. Is is possible using Java code? Please help

Is that your real first name? (-_-) [smiley for the naysayers]
You can get the contents of an Excel cell easily enough
by using the Java Excel API.
The macro is probably vba code (this is my guess.)
You can then intrepret the vba code, getting/putting other cells as
necessary.
 
H

Heiner Kücker

Darshit Rao wrote
I want to run the macro present inside the excel sheet using the Java
code. Is is possible using Java code? Please help


Try

Runtime.exec( "dos_prompt_command" );

--
Heiner Kuecker
Internet: http://www.heinerkuecker.de http://www.heiner-kuecker.de
JSP WorkFlow PageFlow Page Flow FlowControl Navigation: http://www.control-and-command.de
Java Expression Formula Parser: http://www.heinerkuecker.de/Expression.html
CnC Template Technology http://www.heinerkuecker.de/Expression.html#templ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,768
Messages
2,569,574
Members
45,049
Latest member
Allen00Reed

Latest Threads

Top