How to Transfer Data from one excel to another excel using queue in RE-Framework?

Help StudioX
,
1

What i need is to read the First Excel sheet and it will add the all the data to queue and after getting data from queue it will write to another sheet row by row in Re-Framework

1 Like
2

Hey @Vinit_Mhatre

If you can explain the real purpose will be better as the requirement you posted looks funny :sweat_smile:

  • In the init block, just read the excel table from the sheet and bulk upload the items to queue

  • Get the transaction item

  • If output sheet is empty use Write range to write the output & subsequently when the sheet has some existing data use Append range to add the rows from queue

Hope this helps

Thanks
#nK

2 Likes
3

This is my input file:
image
From this excel sheet all the data will get add into the Queue …
After that data will get write into another sheet
image

1 Like
4

Hi @Vinit_Mhatre ,

Could you tell us where are you facing difficulties ?

Are you able to add the row data to Queue ? If you are able to add the data, could you tell us How exactly are you adding the data?

This will help us to suggest you a Solution better.

5

Hey @Vinit_Mhatre

Got it. The above mentioned psuedo logic should work.

Thanks
#nK

6

  • In Init Block i am reading the excel data and passing that data into the queue and same time i am creating datatable to stored the data for my output excel

    image
    image1341Ă—620 21.5 KB

  • And in process transaction block i am storing the specific content from queue into the datatable which i have created earlier

    image
    image1329Ă—618 18.3 KB

    But i am not getting how to write the data into excel sheet…
    can you please see if my workflow is correct or not

7

@Vinit_Mhatre ,

You can use Write Range Activity in the End Block to Write the Datatable which was used in the Add Data Row Activity.

If the Datatable is a Variable and not available outside of the Process Block. Convert the Variable to an Argument with Direction In/Out.

Assign/Declare a variable to the Argument created in the Arguments Section where the Process workflow is invoked. (Change the Scope of the Variable). This variable should have the Updated datatable.

or Rather you can simply use Write Range Activity Inside the Process Block at the End with the Datatable that was used in the Add Data Row Activity. But this would not be a Rigid Solution.

8

Okay thanks, so what if i want to append the data to existing sheet , should i add append range into the process block after “add data row” activity or not?

9

@Vinit_Mhatre ,

You can use the Append Range as well, but If used inside a Process Block,there will be duplicates added to the Excel Sheet since the Data rows will get added to the Datatable after each iteration.

Although this would not be the case if the Append Range was used at the End Block.

10

if i want to append the data i had added this into process transaction block

image
image498Ă—574 12 KB

in another hand if i want to write into another sheet i have added
write range into end process block
image
is this right?

11

@Vinit_Mhatre ,

If you are using these two circumstances separately then, Yes, It should work as Expected.

12

Thanks for your help guys :smiling_face:

1 Like
13

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