How to write web table data to multiple excel sheets based on ID

Help Activities
, ,
1

Hi All,

Can someone help me on below logic implementation.
Unable to write web data to multiple excel sheets based on security number. For one security that works well, i have combined data for all other security ids.

Thanks,
niranjan

2

@niranjan.kummara you just need to follow some steps to get this done. I am assuming that you already have data in the datatable.
Now, first you need to use the filter activity to filter the data based on the security id and then use write range activity and pass the data along with the sheet name in the property and it will write create the worksheet and write the data in that.

Hope that helps.

Let me know if you still have question

3

@Manoj_Batra im new to UIPath could you please share me screenshot or sample workflow. thank help me to build. Thanks a lot for your reply

4

can you share a dummy excel file?

5

@Manoj_Batra, im trying from internal web link, from there i am trying to store data in excel with multiple spreadsheets.

6

DatatableToMultipleExcelWorksheet.zip (11.1 KB)

try this

I have a dummy datatabale that contains 3 rows in it and then I applied the foreach loop to the dt and get the securityid, followed by writing this in the excel

7

@Manoj_Batra Thank you, Sure i will try

1 Like
8

Move data from one Excel sheet to another based on criteria using the filter feature
Open a dataset on an Excel worksheet with filterable criteria.
Select the criteria column from which you want to filter and go to Data > Filter.
Click the small arrow beside the column header to open a drop-down menu.

Regards,
Will