比较Excel和Sql数据库 [英] Comparing excel and Sql database

问题描述

谁能帮我找到解决方案.我用谷歌搜索，没有找到相关的答案.
在编码的UI测试中，我有一个包含某些Testcase_Id和相关方法名称的Excel工作表.
同时，我有一个SQL数据库，其中包含字段的所有测试用例和值.
我的工作是我必须将Excel工作表中的测试用例ID与SQL数据库进行比较.如果测试用例ID相同，则必须仅针对特定方法和特定测试用例运行测试.

我是初学者，请帮助我.

问候，
Revathi

Hi,
Can any one help me to find solution for this.I googled and I have not found related answers.
In coded UI test,I have an Excel Sheet with certain Testcase_Id and related method names in it.
And simultaneously I have an SQL Database where I have all the testcases and values for the fields.
My work is I have to compare the testcase Id from the Excel sheet to the SQL database. when the testcase Id''s are same the test has to be run for the particular method and particular testcase alone.

I am a beginner so please help me.

Regards,
Revathi

推荐答案

最简单的方法是将数据从SQL导出到excel文件，并使用SQL和原始excel文件创建带有测试用例的文件.现在，使用excel函数/宏来过滤和删除具有重复测试用例ID的行.

此 [

The simplest way to do it is to export your data from SQL to an excel file and create a file with test cases from both SQL and the original excel file. Now, use excel functions / macros to filter and remove rows with duplicate testcase ids.

This[^] link should be helpful for the duplicate removal.

这篇关于比较Excel和Sql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！