activity in Rational Function Tester in Java language or Java Scripting

activity in Rational Function Tester in Java language or Java Scripting

Post by Abhina » Mon, 23 Jun 2008 03:48:26


Hi,
I need the code for the following activity in Rational Function
Tester in Java
language or Java Scripting:-

1. To read data from Excel Sheet and write on the other Excel sheet.
2. To read data from the from the VB application and write on a text
file.
3. To search a word "Error" from the string and write the complete
string on the
Excel Sheet.
4. To Read any data from a perticular Cell and write on a defined
sheet of a Excel
sheet.

Waiting for your reply.
 
 
 

activity in Rational Function Tester in Java language or Java Scripting

Post by neora » Tue, 24 Jun 2008 23:59:29

With Excel (actually saving in .xls format) you really only have two
options. 1) OLE/COM automation and 2) Apache POI. If you are writting
this as a library for use in automated test development, you should
have no problems (OLE will be easier). If you are trying to get it
worked into the editor (I believe Functional Tester is eclipse based,
allowing plugins) then you might have alot more work cut out for you.

For COM usage in java, I like JACOB: http://www.yqcomputer.com/
POI is pretty handy too: http://www.yqcomputer.com/