Data-Driven Unit Test with Excel 2007要点

最新推荐文章于 2024-11-03 14:03:52 发布

forlinux

最新推荐文章于 2024-11-03 14:03:52 发布

阅读量1.2k

点赞数

文章标签： excel encoding 测试

本文链接：https://blog.csdn.net/forlinux/article/details/3226191

版权

app.config配置

 
 <?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="microsoft.visualstudio.testtools" type="Microsoft.VisualStudio.TestTools.UnitTesting.TestConfigurationSection, Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
  </configSections>
  <!--add below line(s) for datadriven test.-->
  <connectionStrings>
    <add name="MyExcelConn" connectionString="Dsn=Excel Files;dbq=Unit Test Data for FindOrders.xlsx;defaultdir=.; driverid=790;maxbuffersize=2048;pagetimeout=5" providerName="System.Data.Odbc" />
  </connectionStrings>
  <microsoft.visualstudio.testtools>
    <dataSources>
      <add name="MyExcelDataSource" connectionString="MyExcelConn" dataTableName="Sheet1$" dataAccessMethod="Sequential"/>
    </dataSources>
  </microsoft.visualstudio.testtools>
</configuration>
 

测试方法

 
      [DeploymentItem("Unit Test Data for FindOrders.xlsx")]
       [DataSource("MyExcelDataSource"), TestMethod]
       public void TestMethodUsingExcel()
       {
           string xmlstring = TestContext.DataRow["OrderHistorySearchCriteria"].ToString();
            
       }
 