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?
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It only takes a minute to sign up.Sign up to join this community
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.