Ask a Question

Keyword Test : Writing Values in a New Column

SOLVED
Vallalarasu_P
Frequent Contributor

Keyword Test : Writing Values in a New Column

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

Vallalarasu_P_0-1628784085323.png

 

With Regards
Vallalarasu Pandiyan
https://www.linkedin.com/in/vallalarasupandiyan/
1 ACCEPTED SOLUTION

Accepted Solutions
Marsha_R
Community Hero

Re: Keyword Test : Writing Values in a New Column

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...


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

4 REPLIES 4
Marsha_R
Community Hero

Re: Keyword Test : Writing Values in a New Column

This should help:

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


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
Vallalarasu_P
Frequent Contributor

Re: Keyword Test : Writing Values in a New Column

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 ?

 

Data Driven in KeywordTest.jpg

With Regards
Vallalarasu Pandiyan
https://www.linkedin.com/in/vallalarasupandiyan/
Vallalarasu_P
Frequent Contributor

Re: Keyword Test : Writing Values in a New Column

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

With Regards
Vallalarasu Pandiyan
https://www.linkedin.com/in/vallalarasupandiyan/
Marsha_R
Community Hero

Re: Keyword Test : Writing Values in a New Column

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...


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame

View solution in original post

cancel
Showing results for 
Search instead for 
Did you mean: