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
Building better QA for tomorrow
Comments