Questions tagged [scriptom]

Scriptom is a java library for scripting COM objects

Scriptom is an optional Groovy module originally developed by Guillaume Laforge. It combines the elegant "syntactical sugar" of Groovy with the power of the Jacob library (Java COM Bridge). Scriptom lets you use ActiveX or COM Windows components from Groovy. The result is something that looks eerily similar to VBScript - only groovier.

You can use Scriptom to automate Word or Excel documents, control Internet Explorer, make your PC talk using the Microsoft Speech API, monitor processes with WMI (Windows Management Instrumentation), or browse the Windows Registry using WShell - and much more. Scriptom also provides an easy way to talk to custom VB6 or Microsoft.NET libraries.

Of course, Scriptom can be used only on Microsoft Windows.

See more at scriptom home page

11 questions
4
votes
2 answers

How can I programatically copy and paste with source formatting in PowerPoint 2010?

I am currently automating some PowerPoint 2010 functions in Groovy using Scriptom - though this problem may be generic to any PowerPoint automation approach (ie more of a "VBA macro" issue than the particular environment I'm using?). (Scriptom…
Glennn
  • 467
  • 1
  • 7
  • 18
2
votes
1 answer

Can I fully replace VBA with Groovy's Scriptom?

I have to integrate several Java applications with a system developed in C that embeds VBA for Automation. I would prefer to use Scriptom than VBA. I do not have to integrate with any components developed in VB, just C developed components. Can I…
aym
  • 233
  • 1
  • 4
  • 17
1
vote
1 answer

How to import org.codehaus.groovy.scriptom.* on Groovy?

I'm trying to run a Groovy app to manipulate Excel files on STS (by SpringSource) 2.3.0. My Groovy version is 1.7. Class: package com.mytool import org.codehaus.groovy.scriptom.ActiveXObject /** * @author Mulone * */ class SurveyTool { …
Mulone
  • 3,603
  • 9
  • 47
  • 69
1
vote
0 answers

QC10 to ALM12 : Bug creation script using java and OTA

Here is my problem : With QC10 my groovy script was OK and able to create bug : import org.codehaus.groovy.scriptom.* import java.text.SimpleDateFormat; import java.util.Calendar; import com.jacob.activeX.ActiveXComponent; import…
flytiti44
  • 11
  • 2
1
vote
1 answer

What are the different OTA dlls used for

I am looking to connect ALM and soapUI and while i was looking for the OTA dll i found a bunch of other libraries with the word OTA in their…
Abhishek Asthana
  • 1,857
  • 1
  • 31
  • 51
1
vote
1 answer

how to make scriptom work with soapUI

I want to use scriptom to access COM objects in soapUI but i am not able to get beyond step 1, i.e., installing scriptom. I have tried the steps mentioned in http://www.soapui.org/forum/viewtopic.php?t=96 but when i run a simple command(see…
Abhishek Asthana
  • 1,857
  • 1
  • 31
  • 51
1
vote
1 answer

Scriptom Groovy formating Excel Examples

I am looking for some examples of Groovy doing basic formatting commands for an Excel document. I would also like to know where I can find a repository of these commands too. How would you: Insert a row Format a cell to Short Date, Time, etc. Bold…
Marco Polo
  • 267
  • 1
  • 5
  • 16
0
votes
1 answer

java.lang.IncompatibleClassChangeError using Scriptom 1.6 on Groovy 1.7.10

I try to use scriptom 1.6 on Windows 7 to connect to excel application. However I keep getting the error: Caught: java.lang.IncompatibleClassChangeError: Class org.codehaus.groovy.scriptom.ActiveXObject does not implement the requested interface…
Skarab
  • 6,981
  • 13
  • 48
  • 86
0
votes
2 answers

Scriptom (groovy) leaves Excel process running - am I doing something wrong?

I am using the Scriptom extension to Groovy 1.7.0 to automate some processing using Excel 2007 under Windows XP. This always seems to leave an Excel process running despite my calling quit on the excel activeX object. (There is a passing reference…
Alex Stoddard
  • 8,244
  • 4
  • 41
  • 61
0
votes
1 answer

how to write data to excel using scriptom in groovy?

I am reading properties and their values from soapUI and write them to an excel. I am able to write the unique properties name into an excel def oExcel = new ActiveXObject('Excel.Application') Thread.sleep(1000) assert oExcel != null, "Excel object…
Abhishek Asthana
  • 1,857
  • 1
  • 31
  • 51
0
votes
2 answers

connecting alm and soapUI

I am trying to making soapUI and ALM communicate. I finally got scriptom setup correctly and even got the HP OTA ALM Reference. However i have a few queries... The Reference says You must download and register the COM library on every…
Abhishek Asthana
  • 1,857
  • 1
  • 31
  • 51