Data Scrapping error18

Help Studio
, ,
#1

Hi All,

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.

#2

While writing on to same file use APPEND RANGE ACTIVITY so that every time the data will be entered to the last row of the existing data

Cheers @HeartCatcher

#3

DataScrapping
DataScrapping944Ă—60 6.08 KB

Datascrapping.xlsx (9.0 KB)
Please refer the attachments

#4

@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)

#5

@Palaniyappan ,
@geetishree.rao

Please help me on this

#6

Screenshot (40)
Screenshot (40)1366Ă—768 81.5 KB

I am using the activities as in the attachment but it is not deleting the previous employee details.

#7

Dear Naveen,

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.

Or you can follow the below link
How to Clear Excel Sheet Cell values - Help - UiPath Community Forum

Thanks,
Geetishree Rao

#8

Hi GeetiShree,

Can you please explain a bit more please.
I gone through the article which you shared but I couldn’t understand that.

#9

If possible by taking the input from the excel which attached create a sample workflow pleae

#10

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.

Thanks,
Geetishree Rao

#11

No I am deleting entire data from the excel.
After that I will write the fresh extracted data into the deleted excel

#12

Then in that case You pass the entire range in select range activity and use send hot key delete option

#13

Hi @HeartCatcher

your Steps will as Follows

1 ) Data scraping the following.

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.

Regards

1 Like
#14

Screenshot (41)
Screenshot (41)1366Ă—768 84.4 KB

#15

Hi @HeartCatcher

could you send me a screen shot of your flow!

Or Use Kill excel before Deleting the file!

Regards

1 Like
#16

Screenshot (43)
Screenshot (43)1366Ă—768 82.6 KB

#17

@HeartCatcher

Try using Kill process Process name excel before deleting!

Regards

#18

@pravin_calvin,
Thanks its worked fine.

#19

Kudos @HeartCatcher

Happy automating!

Regards
Calvin

1 Like
#20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.