I'm new to automation testing and also to RFT tool. I tried record and playback by hard-coded values. Now I want to make my scripts dynamic. Hence I use Excel as an external file to fetch data.
How can I fetch data from Excel into RFT?
For this first you need to create an excel, in which yo have specified first row as the column/field names like FirstName, LastName, Address and DOB etc. in the first row and values in the subsequent rows of the same sheet. Save this file (better to save as CSV as they are more lighter than Excel and will not decrease performance when you have a number of test cases)
Then you need to Create a test data pool from the File menu and import your created data file. After that associate the same with your test script and your script will start picking data from your data source.
For step-by-step flow of how to use the same, refer the following links
I have used both Apache POI library to read and write data from an Excel Spreadsheet from an RFT test as well as imported from a CSV file into an RFT datapool. Both work good.
There is a good tutorial on Apache POI at http://www.tutorialspoint.com/apache_poi/. It has simple enough APIs to create/open/read/edit Excel spreadsheets.