Run tests from excel Spreadsheet row by row

Question

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&nbsp;create a &nbsp;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 · Answer

Can someone please help!!

alexanderm · Answer

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 · Answer

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 · Answer

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 · Answer

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

Forum Discussion

Run tests from excel Spreadsheet row by row

5 Replies

Recent Discussions

How can we fetch ColumnIndex based on Column Name for Syncfusion Grid Control in Python

WinForms application crashes on "save as" dialog

Cannot Open Sys Object Tree

Related Content

Java exception when trying to load an Excel spreadsheet as data source

Read excel data/links in javascript test complete

Do I need to load the excel spreadsheet as part of the test for data validation?