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

SirikanChaigul — Mon, 01 Jun 2020 09:16:00 GMT

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
------------------------------

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

hossein.azimi — Sat, 06 Jun 2020 13:56:00 GMT

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
------------------------------

topic RE: Writing data to excel file with condition format takes a lot of time in Product Forum

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

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