BluePrism - Split Excel Data into Sheets using Collections || Reality & Useful
18.9 هزار بار بازدید -
7 سال پیش
-
Hi Friends,
Now we will
Hi Friends,
Now we will discuss about Excel records splitting.
I have a excel sheet having 350 records, I wanna split those records into different sheets per sheet 50 records.
------------------------------------------------------------------------------------
Let's have a look on sheet data
1. At first we need to read data into collection.
2. Create an instance for excel sheet and open the workbook into that.
3. Show the instance using Action stage
4. Get worksheet as collection using Action Stage
Let's run and check
We got the data
5. Create a dummy collection for separate the 50 records from main collection
6. Copy the 50 records into Dummy collection
7. Count the Total records in Main collection using internal collections VBO
8. Create data item for sheet number incrementation
9. Create a worksheet
10. write Dummy collection 50 records set into newly created sheet
11. Count the dummy collection data into new Data item
12. Add these count into start position data item
13. Delete the dummy records collection
14. Increment the flag
Let's run and check before that activate the sheet
The process is failed at 301 and it is trying to read 301 to 351 but 351th record not available let's check it is existed or not the do it
Finally we finished the splitting concept using collections in excel
Thank you
7 سال پیش
در تاریخ 1396/06/10 منتشر شده
است.
18,907
بـار بازدید شده