Best way to do this task

Help Studio
, ,
1

Hi,
I have an excel workbook with 30 excel sheets each having data
I am uploading each sheet as dt in queue using add bulk queue item and now i am not clear how I can get each dt in my process state??
Or Do I need to this task using data table not by queue?

2

@Swarit_Goyal

You want eqch item i mean eqch row or each datatable at once itself?

Because in queue you would have uploaded each item separately so that is what you cna get

Cheers

3

I want each datatable at one time
I am uploading each dt in one

4

@Swarit_Goyal

can you tell or show what is there in your queue item please

did you serialize the datatable and add?

or one thing you can do is in queue add only the sheetnames and for each queue item read each sheet based on the transactionitem in process.xaml transactionitem.SpecificContent("SheetName").ToString will give the sheetname …here SheetName is the key in queue that is to be added

cheers

5

Test.xlsx (14.1 KB)
You can refer this excel workbook, i have added only two sheets but in real time we are getting 20-30

6

@Swarit_Goyal

Please try the above approach

cheers

7

I did the same I am getting each sheet name but now i have doubt how I can get the that whole sheet data with only sheet name in process?

8

@Swarit_Goyal

Read the excel based on sheetname from queue

Cheers