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.
PrathapR : You can use the Groovy Code to write the data into any particular Cell but i would suggest not to use same Excel sheet while reading and writing because
what i have observed with working on same excel workbook is :
Excel file got corrupted if object didn't get closed by your code(anything script failure, run time issue, etc etc) and you try to read the file.
