I have been trying to find a way to insert data in excel. What I am trying to do here is whenever I run my automation script some data are entered into excel worksheet. One more thing is that first column should be incremented when ever I add my data. Below excel sheet is just an example.
Based on the example. If I had ran my application first row have been created using first line after header in excel having test case name and other descriptions. When I run the application again then it should create another row with incrementing with an id of 2
Please help to find a way to insert data to excel.
Let me know if I am on a wrong post instead to voting down for this post.