ABCDEFG
14 years agoContributor
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
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