Blue Prism Product

last person joined: 5 hours ago 

Chat about Blue Prism products
Expand all | Collapse all

MS Excel VBO - performance degradation

  • 1.  MS Excel VBO - performance degradation

    Posted 09-21-2020 18:12
    Hi All,

    We have a process which is having MS Excel (Office 365) as is target application. When it was deployed to production, the interaction was fast and bot was able to read data from excel to collection very quickly. Over the time, the time taken by the bot to read data from excel to collection is taking more time for the same set of record counts. Due to this, the bot has started to miss the SLA and its causing issues for business. Please advise if anybody has encountered such a scenario before? We tried clearing temp files but it didnt help. 

    Version of BP:6.2.2
    Run time resource RAM: 12GB
    RR OS: Win10
    RR Office version: Office365

    Please help!

    Thanks,
    Sajit

    ------------------------------
    Sajit Valloli
    ------------------------------


  • 2.  RE: MS Excel VBO - performance degradation

    Posted 09-21-2020 20:46
    Edited by James Man 09-21-2020 20:46
    A few more questions to hopefully try and narrow down the source of the problem:
    - Is Excel the only application that has this issue?
    - Do other processes which use Excel also have this issue?
    - Has the Excel VBO been customized in any way?
    - Which action are you using?
    - Have you tried using the OLEDB VBO instead to read in the file to a collection?
    - Does rebooting that Runtime Resource temporarily fix the issue?

    ------------------------------
    James Man
    Professional Services
    Blue Prism
    Asia/Hong_Kong
    ------------------------------



  • 3.  RE: MS Excel VBO - performance degradation

    Posted 09-23-2020 01:34
    Working with office applications is very slow through interop libraris and com objects.

    I'm instead using EPPlus (https://github.com/JanKallman/EPPlus) to read/write excel files directly without needing the excel executable running

    ------------------------------
    Brian Christensen
    Developer
    TDC
    Europe/Copenhagen
    ------------------------------