You probably are accessing this tutorial because you want to create, manipulate or perform validations on the excel files used in your automated tests. Perhaps you can create duplicate files, create and set formulae within the excel file, clear contents within the excel file, append data to the excel files to a specific sheet if there are multiple sheets within a workbook. It’s easy to automate such scenarios using the excel commands available within the Worksoft SaaS platform. Worksoft SaaS offers several simple but powerful commands for you that allow the automation to create, interact with (or manipulate or change values) and validate Microsoft Excel files within your application under test.

The table below lists a few examples that will help you implement in creating, manipulating and validating the excel files within your application. The examples in the table below are organized based on the increasing complexity of use cases.