Keyword Test : Writing Values in a New Column

[Vallalarasu_P]

Hi All,

I'm doing Data Driven Testing in Keyword Test Using (DataLoop).  I need to update the value in Column "RunTimeValue" in Keyword test. Can you please suggest a feasible method for implementation

Attached the image of the excel

[Marsha_R]

This should help:

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/exce...

[Vallalarasu_P]

The "Excel - Write Value"  doesn't support adding new rows or column, but supports writing in a single cell which has to be hard coded. Ref Attached, Same for "Cell:" and "Value:"  

Is there an alternative way ?

[Vallalarasu_P]

Also, We are unable to get the current cell value.

[Marsha_R · Accepted solution]

There is a video here and other extensive documentation regarding working with Excel:

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/exce...