cancel
Showing results for 
Search instead for 
Did you mean: 

Writing data to excel file with condition format takes a lot of time

SirikanChaigul
Level 2
Dear Tech team,

     Please help kindly recommend the best method for solving BluePrism problems, it takes a long time to write the data to excel with condition format.
Example
   We use action 'Write Collection' write data to excel file with condition format [takes time 169 minute] and without condition format [takes time 8 minute]
- For writing data to excel 6855 rows and 24 column.
- For condition format [Ex. If data in cell 'A' is blank => Display cell 'A' is red color. ]

Thank you
Best Regards

------------------------------
Sirikan Chaigul
------------------------------
1 REPLY 1

Hi Sirikan

How about using the SQL query by "BPA Object - Data - OLEDB VBO".

Regards

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------