Update excel sheet in process state transaction

Help Studio
1

How to update the same excel sheet , and add data to b,c,d rows by using process state.

2

Hi @Piraisoodan_J

Welcome to forum can u elaborate ur question

3

Screenshot (44)
Screenshot (44)1366Ă—768 110 KB

While using add row acitivy, to the existing excel sheet. The data is adding like this in screensheet. Help me how to update the data in current position.

4

Can u explain the scenario

5

By using reframework

  1. Reads input(NPI) from the attached excel sheet
  2. Open the website - https://npiregistry.cms.hhs.gov/
  3. Search for the NPI one by one and get the details of the Provider from that site and update the same excel sheet
  4. After filling the details for the 3 NPI given in the attached sheet, Bot should do a Name search in the same website for the name “Scott” in the First Name.
6

Done part:

  1. using queue i get the data from excel
    2.searching website all done.

pending:
1.update the existing sheet in process state.

7

Use this challenge to know how to update the sheet

May it helps

Mark it as solution if you got it

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

8

Screenshot (45)
Screenshot (45)1366Ă—768 112 KB

How to create a in_Transactionnumber to be implement.

9

Pass the value of transactionnumber process workflow

10

OK i got.I passed the transtionnumber in workflow

1.while writing a file to excel.
2.i made a excel value in confg file.
3.pass to the excel scope.
4.getting error in the write range box. while pass a string.

Screenshot (47)
Screenshot (47)1366Ă—768 109 KB

11

Write range should only takes datatable not string

12

write cell is working

1.Excel sheet is not updating. while running the workflow it updating somewhere.After completion of workflow, no data in excel sheet. How to solve.

13

Did u assign the cell no dynamically

Please check the workflow I send , GitHub

14

yes.In write cell i given “B”+(in_TranscationNumber+1).ToString

The values are updating somewhere excel while.Not in the specified excel sheet.

15

Is it updating in same excel sheet or other sheet? @Piraisoodan_J did you provided the sheet name correctly

16

It is updating in another excel sheet. I want to be update in the same excel sheet.

17

In your Github workflow

1.The excel sheet is newly created while execution or in the same excel sheet?

18

No it is updating the sheet which is existing

Please check whether the file path and sheet name is same, which u want to update

1 Like
19

Yes, i have checked it its same. i Have given excel “sheet1”

20

Can u share the screenshot of output and process workflow @Piraisoodan_J