Suggestions for the below Process

Help
, , ,
1

Hi,

Am having a following requirement How can I achieve it.

steps:

  1. I have to created the excel file, my excel file contains around 100 records.
  2. My excel file also has header in it.
  3. I want to read the excel file ignoring Excel header and get the count of no of rows.
  4. Now, I want to pass that row count values inside for each activity.
  5. Based on the rows count the loop should run and one by one excel row data should be posted to the orchestrator queue. I don’t want to use bulk add queue activity.
2

Yah that’s lost
—use excel application scope and pass the file path as input
—inside the scope use a read range activity and get the output with a variable of type datatable named dt
-now use a for each row loop and pass dt as input
—inside the loop use ADD QUEUE ITEM activity where mention this row(“yourcolumnname”).ToString in the collections property and mention the queue name I the property panel that we created in TN e orchestrator

Cheers @monish06

3

@monish06

  1. Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘DT’. And also check Add Headers option in properties of Read Range activity.

  2. Then use ForEach Row activity to iterate that DataTable ‘DT’.

    • Inside that use Add QueueItem activity to add itesm to Queue and pass required value.
4

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

5

Why don’t you want to use Bulk add queue item?