VERIFY EXCEL DATA DB
Description
Verify Excel data with the result of executing SQL Statement
– Value 1(*):
[DOWNLOADED FILE] if verifying Excel data is downloaded in [VERIFY DOWNLOADED FILE] Keyword
Local file path is defined in [application.properties] if verifying Excel data in local file
– Value 2(*): The SQL Statement to be executed (defined in [sqlStatement.properties]). The result of executing SQL Statement will be compared to the data of Excel file
– Value 3: The index of start column to be verified in Excel file. Default is the index of first column [1]
– Value 4: The index of end column to be verified in Excel file. Default is getting the last column
– Value 5: The index of start row to be verified in Excel File. Default is the index of first row [1]
– Value 6: The index of end row to be verified in Excel file. Default is getting the last row
Example