Forum Discussion

ABCDEFG's avatar
ABCDEFG
Contributor
14 years ago

DataSink to Excel Write Issue (soapUI Pro)

Hi,

I am facing following challenge in my project using soapUI Pro.

We are comparing Expected results and actual results and resulting “PASS” or “FAIL”. But DataSink write numbers to Excel as text format and because of this Excel is not comparing it against numbers.

I have attached sample test script with this. Please find the attached.

1099INTTestcasesV1.xls > SinglePayoutFrequency (sheet) [Cell S5 – W10]

I guess we can solve this problem, update MS Excel error handling or DataSink write as Number itself in the Excel.
Any thoughts - Help are highly appreciable!

^Thanks

4 Replies

  • Hi,

    Please find the attached error displayed in the soapUI Pro.

    Wed Jan 18 01:40:32 CST 2012:ERROR:java.lang.NullPointerException
    java.lang.NullPointerException
    at java.lang.System.arraycopy(Native Method)
    at jxl.read.biff.File.read(File.java:220)
    at jxl.read.biff.Record.getData(Record.java:117)
    at jxl.biff.XCTRecord.getData(XCTRecord.java:48)
    at jxl.biff.WritableRecordData.getBytes(WritableRecordData.java:71)
    at jxl.write.biff.File.write(File.java:147)
    at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:902)
    at com.eviware.soapui.impl.wsdl.teststeps.datasink.ExcelDataSink.finish(SourceFile:255)
    at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSinkTestStep.finish(SourceFile:248)
    at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalFinally(AbstractTestCaseRunner.java:172)
    at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalFinally(AbstractTestCaseRunner.java:42)
    at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:163)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)


    ^Thanks
  • Hi Folks,

    I think still nobody interested in this subject, not even from the SOAP UI Technicians. But i am still in facing this challenge.

    I am updating the issue with the latest log files from the SOAP UI PRO.

    MY Finding is, if we have some number of the MS Excel formula's inside the Booklet. DataSink wont write it to the Excel storage. Hence it will show this error message.

    Please find the attached error log file and excel sheet.
    I am still researching on this issue. I will update this when i get the solution or with my findings. May be future user's will benefit out of this.

    ^Best regards