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 to this phenomenon in the Scriptom example documentation too.)
Code looks like:
import ...
on Groovy 1.72, I can do this:
import org.codehaus.groovy.scriptom.*
however, i cannot do this:
import org.codehaus.groovy.scriptom.ActiveXObject
it says it cannot reslove class ActiveXObject class......
why?
...
I got a program from
http://kousenit.wordpress.com/2007/03/27/groovyness-with-excel-and-xml.
But I got some very strange results:
I can still print XML, but two records are not readable.
I got exception suggesting something is missing
What might go wrong?
I copied the program and result below.
import org.codehaus.groovy.scriptom.A...
Hi guys,
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 {
static main(args) {
print 'test'
def wshell = new ActiveXObject(...