How to create test cases in order to test columns in an excel file?



  • I have to test an excel file which generated by the system. This file has around 40 columns in it. Do I have to create test cases for each column separately in order to test?

    File contains payment records. Bank details,account numbers,amount etc.

    Can't i check them in a single test case or multiple without having test cases for each column? Please explain



  • It would be better if you write scenarios for each column at least one. The reason beyond is the export file contains the banking pieces of information so there must be some condition and rules to display the data format in the excel.

    Ex: Amount columns may contain the decimal values so it needs to be represented in such format.

    Cover some multiple test cases for most highlighted fields like account no, amount etc..

    Sometimes the special characters will display in the format of junk



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2