Bibu_Philip
New Contributor
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: Unable to write to excel using groovy script in Test Engine
To add more details, I import jxl library and use the associated classes to read/write to the excel file: import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; def project = context.testCase.testSuite.project //this line is commented in Test Engine, works only with local ReadyAPI def project_path = context.expand(project.resourceRoot); //this line is commented in Test Engine, works only with local ReadyAPI def excel_path = project_path + "\\Data\\XXXXX_E2E_Functional_003.xls"; //this line is commented in Test Engine, works only with local ReadyAPI Workbook wb = Workbook.getWorkbook(new File(excel_path)); //when running in Test Engine, "excel_path" is replaced with "\\Data\\XXXXX_E2E_Functional_003.xls" WritableWorkbook wwb = Workbook.createWorkbook(new File(excel_path), wb); //when running in Test Engine, "excel_path" is replaced with "\\Data\\XXXXX_E2E_Functional_003.xls"228Views0likes0CommentsUnable to write to excel using groovy script in Test Engine
Hi, I am trying to read/write to an excel file using Groovy script. It works perfectly in my local ReadyAPI. However, when I run it on Test Engine, I get the below error: Error. java.security.AccessControlException: access denied ("java.io.FilePermission" "\Data\XXXXX_E2E_Functional_003.xls" "read") I get this error on the below line of code: Workbook wb = Workbook.getWorkbook(new File("\\Data\\XXXXX_E2E_Functional_003.xls")); I updated the ReadyAPITestEngine.vmoptions file in Test Engine and added the line at the end: "-Dgroovy.allow.all=true" as mentioned in the documentation link below: https://support.smartbear.com/testengine/docs/admin/config.html#groovy However, I still get the access denied error. Appreciate any help or lead into fixing this error. Thanks! B PhilipSolved307Views0likes2CommentsRe: Data Sink always updates the 1st row in excel sheet
Hi Rich, Thanks for your prompt response! The DataSink works correctly in v3.48.0. That being said, I raised a ticket with Customer Support, and they replied back saying DataSink (with excel) doesn't work outside a DataSource - DataSource Loop. So, if you need to update a specific row in an excel sheet, the only solution is to use groovyscript and import java libraries to achieve this functionality. Thanks! Bibu Philip141Views0likes0CommentsData Sink always updates the 1st row in excel sheet
Hi Team, With the latest version of ReadyAPI (4.39.0), the Data Sink will always write to the first row of the excel sheet when the row is selected by dynamically assigning the cell value for "Start at Cell" parameter of Data Sink. I define a Custom Property called "prop_StartAtCell" in "Custom_Props" Properties step and give an initial value of A1 In groovy script, I dynamically change the value from A1 to A2 or A3 based on certain conditions. In the Data Sink step, I select Excel as the Data Sink, and assign the "Start at Cell" parameter as ${Custom_Props#prop_StartAtCell}. So, while running the test case, it will dynamically assign A2 or A3. However, the Data Sink will always write the data to A1, not to A2 or A3. Looking for a solution or fix for this issue. Thanks!! B PhilipSolved327Views0likes2Comments