Contributions
Trying to Compare two Excel sheet to check if any diffrence and print those diffrence
Trying to compare two excel sheet using Groovy script to match my expected and actual result if there's any diffrence print that. But in Soap Ui usingDATA Sink when trying to find it's not taking groovy script result import jxl.*; import jxl.read.biff.BiffException; import java.io.File; import java.io.IOException; def alert = com.eviware.soapui.support.UISupport; //This will display an information message Workbook rxOrderInput = Workbook.getWorkbook(new File("C:\\Users\\abhishekk\\Desktop\\IIB\\Data Source\\Test2.xls")); Workbook rxOrderOutput = Workbook.getWorkbook(new File("C:\\Users\\abhishekk\\Desktop\\IIB\\Data Source\\Sheets\\Test1.xls")); Sheet sheetInput = rxOrderInput.getSheet(0); Sheet sheetOutput = rxOrderOutput.getSheet(0); int rowCount = sheetInput.getRows(); //log.info(rowCount); int colCount = sheetInput.getColumns(); //log.info(colCount); for(int rowIndex =1; rowIndex<rowCount; rowIndex++) { for(int colIndex = 0 ;colIndex < colCount; colIndex++) { def contentInput = sheetInput.getCell(colIndex, rowIndex).getContents() ; def contentOutput = sheetOutput.getCell(colIndex, rowIndex).getContents(); //log.info(sheetInput.getCell(colIndex, rowIndex).getContents()); //log.info(sheetOutput.getCell(colIndex, rowIndex).getContents()); if(contentInput != contentOutput) { //log.info(contentInput); //log.info(contentOutput); result= ("Row:"+rowIndex+" Column:"+colIndex+"\n"+contentInput + "\n"+contentOutput); } } }1.7KViews0likes2CommentsRe: how Drag and drop file from one folder to another in local deive in Soap PRO Version ?
I have to create test case to check file conversion of several files from .XML to .JSON format by dragging file from one folder in my local to another folder in the server using Soap UI Pro. For that in PRO Data Source i can use Directory but for dropping any option is available in Soap UI. Need to help todo this9 years agoPlace ReadyAPI QuestionsReadyAPI Questions1KViews0likes1Comment