Hi,
 
I am new to Grinder and I am attempting to call a spreadsheet from Jython so that I can read a list of values from the spreadsheet as input data so that the input data is different per thread and can match something in the database.
 
I have installed Apache POI and put in in my classpath. When I try to import this from the command line it can however when I try to run the test from Grinder (with the reference to apache in the script -
from org.apache.poi.hssf.usermodel import *
from java.io import FileInputStream
 
I get the message ImportError: no module named apache.
 
In the grinder.properties I have set
 
# start the Grinder processes.
grinder.jvm.classpath = \poi-3.6\poi-3.6-20091214.jar; \poi-3.6\poi-contrib-3.6-20091214.jar; \poi-3.6\poi-ooxml-3.6-20091214.jar;\poi-3.6\poi-ooxml-schemas-3.6-20091214.jar;\poi-3.6\poi-scratchpad-3.6-20091214.jar;
 
Would be grateful if someone can give me some advice - this looks like something I need to set within Grinder and the import apache is recognised from the command line.
 
I am using Grinder 3.
 
Also, if anyone has adivce on the best way to call a data list for insertion into parameters then this would be much appreciated (i.e. text file, from jave etc).
 
Thanks in advance,
Joanne
 
This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy by an authorised signatory.  The contents of this email may relate to dealings with other companies within the Detica Limited group of companies.

Detica Limited is registered in England under No: 1337451.

Registered offices: Surrey Research Park, Guildford, Surrey, GU2 7YP, England.