Forum Discussion

kpkannan83's avatar
kpkannan83
14 years ago

Working with Excel Files

I am just working with sample orders.exe (Delphi Application) to iterate New Order creation by using DDT driver. I am having input data in an excel (See the attachment) to create a New Order. I have successfully iterated  the New Order creation with the data in the excel file. The excel file contains totally 3 records so that 3 new orders have been created.



My aim is, after every successful creation of new order with the data in the excel sheet, i want to update the status column in the excel sheet as "Pass".

If the new order creation fails, it means if the new order doesn't match with the excel record then the status column should be updated as "Fail". How to achieve this?

1 Reply

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    14 years ago
    The DDT drivers are read-only connections to the data records so, within those drivers, you cannot update the spreadsheet.  I would suggest using a check point or some other means so that, when the loop is done, you verify the existence of the new order and log it to the TC Test Log rather than writing it out to the DDT data source.  As a general rule of thumb, updating your data source used for executing a test as part of the test "damages" the reliability of the test because then the data source is no longer in the state it was when the test was executed.