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

No members online now.

Forum statistics

Threads
473,766
Messages
2,569,569
Members
45,043
Latest member
CannalabsCBDReview

Latest Threads

Top