Hi
Can any one help me, how to write the Soap response in to an existing excel file in specific cell, I tried a lot, but not able to find solution yet.
I am able to save the response in to new excel file. I am new to soapUI and groovy scripting. Please let me know if any other details are required from my end.
Thanks & Regards,
Murugan Chelliah
Hi Rao,
Thanks for your quick response.
Yes, I tried, searched in intranet and in forum, but I didn't get the correct sample code. Can you please help me on this..
I tried the below code, But it is giving the error "jxl.read.biff.BiffException unable to recognize OLE stream"
import jxl.*
import jxl.write.*
import jxl.read.biff.BiffException;
def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def holder = groovyUtils.getXmlHolder("validateFile#Response")
//def request=groovyUtils.getXmlHolder("validateFile#Request")
log.info holder.getXml()
def inputDataFileName= "D:\\userdata\\mchellia\\Desktop\\SSDP\\SSDP Test Automation\\NSCMD\\InputValues\\tmp_input_copy1.xls"
def inputDataSheetName="Sheet1"
Workbook workbook = Workbook.getWorkbook(new File(inputDataFileName));
WritableWorkbook copy = Workbook.createWorkbook(new File(inputDataFileName),workbook);
WritableSheet sheetl = copy.getSheet(inputDataSheetName);
log.info(sheet1.isHidden())
xPath1 = "//*:uniqueid/text()"
log.info holder.getNodeValue(xPath1)
Cell cell2Update = sheet.getRow(3).getCell(19);
cell2Update.setCellValue(xPath1);
copy.write();
copy.close();
workbook.close();
