Problem:

How to read from/write to Excel file using a TestPartner test script

Resolution:

1. Open the attachment “TestPartner_Script.txt” at the bottom of this page, then copy and paste the text into a new TestPartner test script.
2. Open the attached MS Excel file, Spreadsheet_Data.xlsx.
3. Add a reference to Excel in TestPartner Tools > References, e.g. Microsoft Excel 14.0 Object Library
4. Run the test script, it will write to and retrieve data from specific columns and rows in Excel


 

Attachments:

1200.TestPartner_Script.txt

4338.Spreadsheet_Data.xlsx