I am doing the data scrapping inside a website portal here I will get many tickets BOT needs to check each and every ticket after that I need to write into an excel at last it as to be upload into a portal.
But each time I just want to upload the individual ticket into a portal which will be in excel was extracted by BOT.
First time it will write into excel correctly(Only values not the headers) but for second time it is also taking the header and writing into the excel(in this case or for each case I just need to write the Values from excel into the portal) someone please help me on this.
@Palaniyappan,
Thanks for the reply , actually BOT will scrap the data of a Ticket then it is write into excel(only one employee details it is getting correct for the first time) but in for second employee details I just want to delete the first extracted data then I want to write the second employee details into excel then upload to a portal(I meant I want to delete the first employee details after uploading into the portal then I want to write second employee details and upload to the portal after uploading the data BOT needs to delete the excel data of second employee details, after that I want to write the third extracted data and write into excel and upload then delete the data related to 3rd employee details and the loops continue based on the number of the tickets)
Use Write cell option instead of delete range. Give the sheet name “sheet1” and Range for ex. “A2:D25”.
Below field input “”. It will clear the contents in an given range.
Dear Naveen,
Everytime you are deleting one record(one row)?
Use the Write Cell activity and pass the range of the Row say A2:Z2 (if first row is header)
Then use write range to write the data.
2)Use The path Exists Activity.(Create a path of the Excel file path)
(“Yourpath\Filename.xlsx”)
3)If Path exists then delete file using the delete file activity.
else write Range the dataScraped Extracted Datatable with Add headers property checked.
