Run tests from excel Spreadsheet row by row

[apease01]

Hi,



I am trying to write a script (jscript) that will work through a excel spreadsheet row by row. If a column has True in it, I would like it to go off and run a specific test assigned to that column.



Also, there will be data in the spreadsheet that I will need to input into a website, so would like to be able to create a  test that will go through the relevant cells in the row and pick out the information I need and populate eg a website form.



Can someone please help me with the script?



Thanks

[apease01]

Can someone please help!!

[AlexanderM]

Hi Andy,





We recommend that you work with Excel via COM (the "Excel.Application" object). To get the object you can use the following code:

ExcelObject = Sys.OleObject("Excel.Application")

You can use the following online MSDN article to find out how to work with the Excel.Application object:

http://msdn.microsoft.com/en-us/library/wss56bz7(VS.80).aspx

[shail2812]

Hi Andy,

Did you get the answer you were looking for ? Otherwise I can help. We are reading the data from different tabs of excel and setting that data in different fields in the screen.

The next thing we are planning to do is to execute the tests conditionally based on some condition, which if true would execute the test and if false, skip the test. FYI, I thinik TC also provides this kind of functionality to conditionally execute the test (not very sure).



you can mail me at shailendra.chauhan@headstrong.com

[shail2812]

Hi Andy,

Did you get the answer you were looking for ? Otherwise I can help. We are reading the data from different tabs of excel and setting that data in different fields in the screen.

The next thing we are planning to do is to execute the tests conditionally based on some condition, which if true would execute the test and if false, skip the test. FYI, I thinik TC also provides this kind of functionality to conditionally execute the test (not very sure).



you can mail me at shailendra.chauhan@headstrong.com

[shail2812]

Hi Andy,

Did you get the answer you were looking for ? Otherwise I can help. We are reading the data from different tabs of excel and setting that data in different fields in the screen.

The next thing we are planning to do is to execute the tests conditionally based on some condition, which if true would execute the test and if false, skip the test. FYI, I thinik TC also provides this kind of functionality to conditionally execute the test (not very sure).



you can mail me at shailendra.chauhan@headstrong.com