Thanks for reply Nastya_Khovrina .
1)Yes, I can able to do with Apache POI with Groovy script. But would like to use data sink steps, since using paid version.
2) Yesterday had a call with SmatBear system engineer and opened a ticket for Data Sink steps.
Thank you Himanshu!!
PrathapR Please keep us updated on the investigation results with the support team.
PrathapR , I see that you got a temporary solution in the support ticket. Let me post it here and mark it so, as well.
Do not hesitate to update this thread!
>>
The only way I see out of the box to add headers when creating a new sheet in a excel file is to use a template file. The template file will be written to the Output File in the exact format it is in so the template file should be the same file as the output file. The thing that would need to change dynamically is the "Start at cell" attribute. If you save the last row the output excel file was written to a testsuite property, increment it, and then use dynamic property expansion to retrieve it in the "Start at cell" attribute the new values will be written to the correct row each time. Below is an example of a dynamic property expansion that can be used in the "Start at cell" attribute.
${= return 'A' + context.expand( '${#TestSuite#rowNum}' )}
If the property "rowNum" value is 3 , the dynamic property expansion will return A3 as the "Start at cell" value and data will be written starting at cell A3. Below is a link on dynamic property expansion and how to save values to properties using Groovy.
https://support.smartbear.com/readyapi/docs/testing/properties/expansion.html#dynamic
https://support.smartbear.com/readyapi/docs/testing/scripts/samples/variable.html#get-and-set-properties
<<
