Re: Getting argument type mismatch exception while running the test -- Pls help

[Praveen]

Never mind.. I just fixed it. Thanks!

On Monday, January 14, 2013 1:32:22 PM UTC-6, Praveen wrote:

I'm trying to run the following test and I get the exception mentioned below. The exception is not even from my class.. Pls help me.

import java.io.FileInputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.poifs.filesystem.POIFSFileSystem;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.testng.annotations.DataProvider;

import org.testng.annotations.Test;

public class ReaderTest {

public int ColumnNumbers;

public Object[][] data;

@Test(dataProvider = "readExcelData")

public void testCase(String something){

System.out.println("..........Test Started Sucessfully..........");

}

@DataProvider

public Object[][] readExcelData() {

FileInputStream myInput;

Row myRow = null;

Cell myCell = null;

int count1 = 0;

int automationTCID = 0;

int testCaseOccuranceCount = 0;

int rowIndex = 0;

int totalColumnCount = 0;

String fileName = "C://test.xls";

try {

myInput = new FileInputStream(fileName);

POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);

Workbook myWorkBook = new HSSFWorkbook(myFileSystem);

Sheet mySheet = myWorkBook.getSheet("home");

while (true) {

myRow = mySheet.getRow(rowIndex++);

if (myRow == null)

break;

myCell = myRow.getCell(automationTCID);

if (myCell != null) {

if (myCell.getStringCellValue().contentEquals("tester2")) {

testCaseOccuranceCount++;

totalColumnCount = myRow.getLastCellNum();

System.out.println("test Case count is "+testCaseOccuranceCount);

System.out.println("total column count is "+totalColumnCount);

}

}

}

rowIndex = 0;

data = new Object[testCaseOccuranceCount][totalColumnCount];

while (true) {

myRow = mySheet.getRow(rowIndex++);

System.out.println("row index is "+rowIndex);

if (myRow == null)

break;

myCell = myRow.getCell(automationTCID);

if (myCell != null) {

if (myCell.getStringCellValue().contentEquals("tester2")) {

for (int j = 0; j < totalColumnCount; j++) {

myCell = myRow.getCell(j);

myCell.toString();

data[count1][j] = myCell;

System.out.println("data content is "+data[count1][j]);

}

count1++;

}

}

}

}

catch(Exception e){

e.printStackTrace();

}

System.out.println("Done with the data provider");

return data;

}

}

The exception is 

FAILED: testCase("tester2")

java.lang.IllegalArgumentException: argument type mismatch

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(MethodInvocationHelper.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(TestMethodWorker.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:1197)

at org.testng.TestNG.runSuitesLocally(TestNG.java:1122)

at org.testng.TestNG.run(TestNG.java:1030)

at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:111)

at org.testng.remote.RemoteTestNG.initAndRun(RemoteTestNG.java:204)

at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:175)

===============================================

    Default test

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

===============================================

===============================================

Default suite

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

===============================================

[TestNG] Time taken by org.testng.reporters.SuiteHTMLReporter@68e08edd: 125 ms

[TestNG] Time taken by org.testng.reporters.JUnitReportReporter@58c08b39: 13 ms

[TestNG] Time taken by org.testng.reporters.jq.Main@1023f599: 56 ms

[TestNG] Time taken by org.testng.reporters.XMLReporter@61070a02: 12 ms

[TestNG] Time taken by [FailedReporter passed=0 failed=0 skipped=0]: 14 ms

[TestNG] Time taken by org.testng.reporters.EmailableReporter@2c709cb5: 8 ms