mani1
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: How do I change the location of the xml project files for SOAPUI projects?
Hi, It is easy. You need to select the project from SOAPUI for which you want to change the location, right click and click on "Save Project as" option, give the path where you want to save the project xml files. Thanks Mani3KViews0likes0CommentsRe: How to write the Soap response in to an existing excel file in specific cell
Hi, Finally I find the solution. Find the below code import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.ss.usermodel.*; import java.io.*; def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) def holder = groovyUtils.getXmlHolder("validateFile#Response") log.info "soap xml >>>>>>>>>>>>>>>>:"+holder.getXml() xPath1 = "//*:uniqueid/text()" log.info "uniqueid value >>>>>>>>>>>>>>>:"+holder.getNodeValue(xPath1) iniqueidVal=holder.getNodeValue(xPath1) FileInputStream fIpStream= new FileInputStream(new File("D:\\tmp_input.xls")); HSSFWorkbook wb = new HSSFWorkbook(fIpStream); // accessing your existing sheet HSSFSheet worksheet = wb.getSheetAt(0); Row row = worksheet.getRow(2); //Create a new cell in current row Cell cell = row.createCell(18); cell.setCellValue(iniqueidVal); //log.info(xPath1) fIpStream.close(); //Close the InputStream FileOutputStream output_file =new FileOutputStream(new File("D:\\tmp_input.xls")); wb.write(output_file); output_file.close(); Thanks Mani5KViews1like0CommentsRe: Inserting data to excel with Groovy script
Hello Don, Thanks for your response, Yes, I am getting the response from API and I want to update the response content in to an existing excel file in to a specific cell (row, column) and it shouldn't delete any existing cell value (row, column) from that excel. I am able to update the response in to new excel file, which I don't want. Please help me to solve this, it would be fine if any sample code with example, will be very helpful Thanks & Regards, Murugan Chelliah25KViews0likes1CommentRe: How to write the Soap response in to an existing excel file in specific cell
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();5KViews0likes2CommentsHow to write the Soap response in to an existing excel file in specific cell
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 Chelliah5.1KViews0likes4CommentsRe: Inserting data to excel with Groovy script
Hi I am having the same requirement. I want to update the soap response into existing excel file with specific row and column, I tried, but Not get the result yet. I am able to save the response into new excel sheet, Can anyone help me on this, I am new to this groovy script. Thanks & Regards, Murugan Chelliah25KViews0likes3CommentsProblem while sending atatchement as excel file in SOAP request
I want to attach an excel file in soap request, I tried Using cid:notation, and base64, both is getting failed. In attachment pane , when I choose the unique-identifier that was specified with the cid: notation in payload, the TYPE column should not be changing as"CONTENT". It is showing as "XOP" and the content-type is showing as "application/octet-stream" I don't know what is the issue Please help me on this, Let me know if any other details are required. Please let me know if any other details are required. I am using free version of soapUI 5.2.0. I am new to SOAP UI. Thanks & Regards, Murugan Chelliah816Views0likes0Comments