It is Possible, We can Microsoft excel in TOSCA TestSuite by using Excel Engine. Various operations like read data, write data in excel can be performed using excel engine. Excel Engine is not a part of standard modules, we need to DOWNLOAD and then import it. The SEQUENCE of operations (to read / write excel) is – Open Excel workbook, Set Active workbook, Set Active Worksheet, Excel create range, Set Active range, set excel HEADER, After all these set of STEPS, we can have read / write / verify data in/from excel followed by Closing excel workbook.

It is Possible, We can Microsoft excel in TOSCA TestSuite by using Excel Engine. Various operations like read data, write data in excel can be performed using excel engine. Excel Engine is not a part of standard modules, we need to download and then import it. The sequence of operations (to read / write excel) is – Open Excel workbook, Set Active workbook, Set Active Worksheet, Excel create range, Set Active range, set excel header, After all these set of steps, we can have read / write / verify data in/from excel followed by Closing excel workbook.