您的位置: 首页  >  技术问答  >  TestNG脚本无法从.bat文件运行时打开Excel

TestNG脚本无法从.bat文件运行时打开Excel

分类: 技术问答 • 2022-04-01 10:03:19

TestNG脚本无法从.bat文件运行时打开Excel

问题描述：

我的TestNg脚本使用DataProvider使用来自Excel的输入数据。当我从Eclipse运行testng.xml文件时，它工作正常。 但是，当我尝试从.bat文件运行同样的功能时，它不起作用。它尝试打开Excel文件时失败。 请帮忙。TestNG脚本无法从.bat文件运行时打开Excel

这是我的DataProvider类：

@DataProvider(name="DataProvider") 
public static Object[][] passExcelData(Method m) throws BiffException, IOException 
{ 
    String sheetName = m.getName(); 
    config = new ExcelDataConfig("inputData.xlsx", sheetName); 
    int rows = config.getRowCount(sheetName); 
    int cols = config.getColCount(sheetName); 
    Object[][] data = new Object[rows][cols]; 

    for(int i=0; i<rows; i++) 
    { 
     for(int j=0; j<cols; j++) 
     { 
      data[i][j] = config.getData(sheetName, i, j); 
     } 
    } 
    return data; 
    }

而且下面是BeforeClass和测试调用的DataProvider：

@BeforeClass 
public void setup() throws InterruptedException 
{ 
    System.setProperty("webdriver.chrome.driver", rootFolder +"Drivers\\chromedriver.exe"); 
    driver = new ChromeDriver(); 
    driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS); 
    driver.manage().window().maximize(); 
    System.out.println("setup done"); 
} 

@Test(priority = 7, dataProvider="DataProvider") 
public void EmailAlerts(String Product, String URL, String username, String password) throws InterruptedException 
{ 
    functionName = Product + "_EmailAlerts_" +username; 
    HomePage(URL); 
    Login.loginProcess(username, password); 
    EmailAlerts.EmailAlerts_Process(); 
    Logout(); 
}

它没有经过任何错误本身。 BeforeClass运行没有问题。它打开浏览器并显示“安装完成”消息。它甚至调用DataProvider类，但无法打开excel文件。 只有从.bat文件运行时才会出现此问题。如果我从excel部分读取数据并在DataProvider类中对输入数据进行硬编码 - 同一个bat文件工作正常。

我已经简化我的剧本和冗长设置为10。下面是最新的：

public class Master { 
@Test 
public void sample() throws Exception 
{ 
    System.out.println("INSIDE SAMPLE"); 
    FileInputStream fis = new FileInputStream ("C:\\Automation\\Test\\inputData.xlsx"); 
    System.out.println("FILE"); 
    XSSFWorkbook wb = new XSSFWorkbook(fis); 
    System.out.println("WORKBOOK"); 
    wb.getSheet("MyDetails"); 
    System.out.println("SHEET"); 

    System.out.println(wb.getActiveSheetIndex()); 
}

}

下面是bat文件运行时日志：

C:\Automation\Test>cd C:\Automation\Test 

C:\Automation\Test>set ProjectPath=C:\Automation\Test 

C:\Automation\Test>echo C:\Automation\Test 
C:\Automation\Test 

C:\Automation\Test>set classpath=C:\Automation\Test\bin;C:\Automation\Test\lib\* 


C:\Automation\Test>echo C:\Automation\Test\bin;C:\Automation\Test\lib\* 
C:\Automation\Test\bin;C:\Automation\Test\lib\* 

C:\Automation\Test>java org.testng.TestNG C:\Automation\Test\testng.xml 
... 
... TestNG 6.8beta 20120825_1010 by C?dric Beust ([email protected]) 
... 

[TestRunner] Running the tests in 'Test' with parallel mode:false 
[RunInfo] Adding method selector: [email protected] 
priority: 10 
[TestClass] Creating TestClass for [ClassImpl class=Master.Master] 
[TestClass] Adding method Master.sample()[pri:0, instance:null] on TestClass cla 
ss Master.Master 
[XmlMethodSelector] Including method Master.sample() 
[TestNG] Running: 
    C:\Automation\Test\testng.xml 

[SuiteRunner] Created 1 TestRunners 
[TestRunner] Running test Test on 1 classes, included groups:[] excluded group 
s:[] 
===== Test class 
Master.Master 
    @Test Master.sample()[pri:0, instance:[email protected]] 
====== 
[Invoker 6738746] Invoking Master.Master.sample 
INSIDE SAMPLE 
FILE 
===== Invoked methods 
    Master.sample()[pri:0, instance:[email protected]] 18154549 
===== 
Creating C:\Automation\Test\test-output\Suite\Test.html 
Creating C:\Automation\Test\test-output\Suite\Test.xml 
FAILED: sample 
java.lang.NoClassDefFoundError: org/apache/poi/xssf/usermodel/XSSFWorkbook 
     at Master.Master.sample(Master.java:79) 
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
     at java.lang.reflect.Method.invoke(Unknown Source) 
     at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocat 
ionHelper.java:80) 
     at org.testng.internal.Invoker.invokeMethod(Invoker.java:714) 
     at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901) 
     at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231) 
     at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWork 
er.java:127) 
     at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111) 
     at org.testng.TestRunner.privateRun(TestRunner.java:767) 
     at org.testng.TestRunner.run(TestRunner.java:617) 
     at org.testng.SuiteRunner.runTest(SuiteRunner.java:334) 
     at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329) 
     at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291) 
     at org.testng.SuiteRunner.run(SuiteRunner.java:240) 
     at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52) 
     at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86) 
     at org.testng.TestNG.runSuitesSequentially(TestNG.java:1198) 
     at org.testng.TestNG.runSuitesLocally(TestNG.java:1123) 
     at org.testng.TestNG.run(TestNG.java:1031) 
     at org.testng.TestNG.privateMain(TestNG.java:1338) 
     at org.testng.TestNG.main(TestNG.java:1307) 
Caused by: java.lang.ClassNotFoundException: org.apache.poi.xssf.usermodel.XSSFW 
orkbook 
     at java.net.URLClassLoader.findClass(Unknown Source) 
     at java.lang.ClassLoader.loadClass(Unknown Source) 
     at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) 
     at java.lang.ClassLoader.loadClass(Unknown Source) 
     ... 24 more 


=============================================== 
    Test 
    Tests run: 1, Failures: 1, Skips: 0 
=============================================== 


=============================================== 
Suite 
Total tests run: 1, Failures: 1, Skips: 0 
=============================================== 

Creating C:\Automation\Test\test-output\old\Suite\toc.html 
Creating C:\Automation\Test\test-output\old\Suite\Test.properties 
Creating C:\Automation\Test\test-output\old\Suite\index.html 
Creating C:\Automation\Test\test-output\old\Suite\main.html 
Creating C:\Automation\Test\test-output\old\Suite\groups.html 
Creating C:\Automation\Test\test-output\old\Suite\methods.html 
Creating C:\Automation\Test\test-output\old\Suite\methods.html 
Creating C:\Automation\Test\test-output\old\Suite\methods.html 
Creating C:\Automation\Test\test-output\old\Suite\methods-alphabetical.html 
Creating C:\Automation\Test\test-output\old\Suite\methods-alphabetical.html 
Creating C:\Automation\Test\test-output\old\Suite\methods-alphabetical.html 
Creating C:\Automation\Test\test-output\old\Suite\classes.html 
Creating C:\Automation\Test\test-output\old\Suite\reporter-output.html 
Creating C:\Automation\Test\test-output\old\Suite\methods-not-run.html 
Creating C:\Automation\Test\test-output\old\Suite\testng.xml.html 
Creating C:\Automation\Test\test-output\old\index.html 
[TestNG] Time taken by [email protected]: 53 ms 
[TestNG] Time taken by [email protected]: 3 ms 
Creating C:\Automation\Test\test-output\junitreports\TEST-Master.Master.xml 
[TestNG] Time taken by [email protected]: 4 ms 
Creating C:\Automation\Test\test-output\testng-failed.xml 
Creating C:\Automation\Test\test-output\Suite\testng-failed.xml 
[TestNG] Time taken by [FailedReporter passed=0 failed=0 skipped=0]: 6 ms 
Creating C:\Automation\Test\test-output\index.html 
[TestNG] Time taken by [email protected]: 40 ms 
Creating C:\Automation\Test\test-output\testng-results.xml 
[TestNG] Time taken by [email protected]: 6 ms 

C:\Automation\Test>pause 
Press any key to continue . . .
+0

请提供有关您的信息的更多信息。请编辑您的问题以包含您使用的脚本以及显示的错误消息（如果有）。 –

答

数据提供者方法不应该抛出异常。将它们管理到你的方法中，你就会明白你的代码有什么问题。

我敢打赌，你有一个类路径问题，并且inputData.xlsx不适用于与bat文件一起运行的预期位置。

+0

感谢您的回复。 –

+0

下面是我的bat文件： –

+0

cd C：\ DCE \ Automation set ProjectPath = C：\ DCE \ Automation set classpath =％ProjectPath％\ bin;％ProjectPath％\ lib \ * java org.testng.TestNG％ ProjectPath％\ testng.xml pause –

答

是的，现在已经解决了。我的poi文件位于项目文件夹\ lib \ poi文件夹中。我已将它们移至项目文件夹\ lib。它的工作原理。 谢谢@Julien Herr。

相关推荐