Write the data to from Queue to of excel

Help Studio
1

Hi Team,

Dispatcher – read the data from excel Sheet1 (with 2 columns) and populate the queue. - DONE

Performer – the same data which I have put in to the queue should be entered in to the Sheet 2

All the queue items should be copied and pasted to the excel sheet.

Using the gettransaction item, I am able to extract the items of the queue. but unable to write it to the excel in the Sheet 2

Here is what i did
Transactions.xlsx (10.6 KB)
write this data from sheet 1 to sheet 2.
in performer
created the build data table

image
image918×325 13.1 KB

  • in the process.xaml file
    i tried to populate the row by row data in to the DT as below

image
image691×576 18.8 KB

Here is what error i am getting

image
image1334×569 69.3 KB

i tried to fix this, i dont no why its giving like this error

{in_TransactionItem.SpecificContent(“OnUsCheck”).ToString, in_TransactionItem.SpecificContent(“NotOnUsCheck”).ToString}

Can anyone please guide me on this.

Regards,
Seema

2

Hi @Seem

You are missing 1 column value in your input array, Kindly try with this one in your add data row activity

{String.Empty,in_TransactionItem.SpecificContent(“OnUsCheck”).ToString, in_TransactionItem.SpecificContent(“NotOnUsCheck”).ToString}

Regards

3

Hi @Seem

You are adding two values in to a row in add data row activity and there is three columns in Build datatable.

The adding values in add data row should matches the number of columns in datatable. Then you have to add three values in each row in add data row activity. Then this error sorts.

Hope it helps!!

4

@mkankatala
Ok let me try that.
actually in my queue i have enterd only 2 columns , so i am removing one column and making the build data table - with only 2 columns

again ai am getting the same error .
Add Data Row: Input array is longer than the number of columns in this table.

@fernando_zuluaga

I am getting this below error with ur approach

image
image1514×661 101 KB

5

If you’re just trying to move data from one Excel file to another, having a dispatcher and performer and using a queue is all unnecessary.

Read Range into datatable from original file
Write/Append Range from datatable into new file

And you definitely shouldn’t be using REFramework for this, it’s massively overcomplicating your process.

6

i have to use RE framework only

7

Why do you have to use REF?

8

Hi All,

Can anyone please help me with this issue, as its critical, please help. have to finish it ASAP.

9

The error saying the workflow file is not found in your code. Check any workflow which is invoked is deleted in your project.

Hope you understand!!

10

Hi @Seem . Can you check whether the invoke for InitAllapplications in Init state of Main.xaml has the variable set for datatable? Also the argument type of Datatable in InitAllApplications should be either in/out or out.
If you can share the Main.xaml would be easy to figure out.

11

Hi @Seem

From the latest screenshot error i can understand that tgere is probelm with your UiPath.System.Activities, can you please remove that package and reinstall with the latest version from manage packages and check it whether it worked or not.