Forum Discussion

apease01's avatar
apease01
Occasional Contributor
16 years ago

Run tests from excel Spreadsheet row by row

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...
AlexanderM's avatar
AlexanderM
Icon for Staff rankStaff
16 years ago

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