DETAILED READ SECTION

Excel Utilities Creation Coding Exercises



Excel utilities creation very much required for any QA Engineer as all test scripts require some level of interaction with Data and excel utilities help you get interacted with excel sheets where many enterprises maintains its test data.


In this post we will share common utilities that will be helpful for QA Engineers to use both live projects and to solve coding exercises which sometimes given by Overseas employers while hiring Automation QAs.


Exercise 1:

Write method to returns the row count in a sheet


Exercise 2:

Write method to returns the data from a cell based on Column Name and Row Number


Exercise 3:

Write method to returns the data from a cell based on Column Number and Row Number


Exercise 4:

Write method to write cell data based on colName and rowNumber with given data


Exercise 5:

Write method to write cell data based on colName and rowNumber with given data and URL


Exercise 6:

Write method to addsheet in given excel


Exercise 7:

Write method to remove sheet in given excel


Exercise 8:

Write method to add column in given sheet


Exercise 9:

Write method to remove column in given sheet


Exercise 10:

Write method to find whether sheets exists


Exercise 11:

Write method to returns number of columns in a sheet


Exercise 12:

Write method to add hyper link for given sheetname and screen shot column name


#NGAutomation

Building better QA for tomorrow