MS EXCEL VBO - Action Get Worksheet Range as Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-02-21 12:25 PM
Hi,
This action not working propely, the result is none (zero rows). How can I know what is going on ?
I'm using Blue Prism 6.9 and EXCEL 2013
Regards,
------------------------------
Ivo Corrêa
------------------------------
This action not working propely, the result is none (zero rows). How can I know what is going on ?
I'm using Blue Prism 6.9 and EXCEL 2013
Regards,
------------------------------
Ivo Corrêa
------------------------------
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-02-21 03:31 AM
Hi, Ivo.
I would strongly recommend opening a support ticket, so we can better support you and analyze the error.
Do you have access to the portal to open a ticket? If not, just send an email to support@blueprism.com.
Thank you
Sergio
------------------------------
Sergio Bentim
Customer Engineer
Technical Support
America/Mexico_City
------------------------------
I would strongly recommend opening a support ticket, so we can better support you and analyze the error.
Do you have access to the portal to open a ticket? If not, just send an email to support@blueprism.com.
Thank you
Sergio
------------------------------
Sergio Bentim
Customer Engineer
Technical Support
America/Mexico_City
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-02-21 09:49 AM
Hi Ivo
Can you give more details on the issue please such as the input parameters you using for the action and possibly some screen shots inputs/outputs for this?
Thanks
------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------
Can you give more details on the issue please such as the input parameters you using for the action and possibly some screen shots inputs/outputs for this?
Thanks
------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-06-21 01:39 PM
hi Ivo!
It's a known issue. In "get worksheet as collections" page from Blue Prism VBO you can read this: "
Office 2013 onwards
There are known issues when attempting to read and write data using the Excel VBO with the application set to run in background mode. These issues can be overcome by using the Show action"
Try putting the run in background mode and not to use the "Show" action
Best Regards
------------------------------
Aníbal Facundo Urrestarazu
Lead Developer
Ctrl365 - Argentina
------------------------------
It's a known issue. In "get worksheet as collections" page from Blue Prism VBO you can read this: "
Office 2013 onwards
There are known issues when attempting to read and write data using the Excel VBO with the application set to run in background mode. These issues can be overcome by using the Show action"
Try putting the run in background mode and not to use the "Show" action
Best Regards
------------------------------
Aníbal Facundo Urrestarazu
Lead Developer
Ctrl365 - Argentina
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-06-21 12:39 PM
Even in my case, some actions within MS excel VBO started throwing errors after BP and Windows upgrade.
We did add the Show stage for the excel instances opened, and everything went fine.
------------------------------
Murali Krishna
RPA Consultant
------------------------------
We did add the Show stage for the excel instances opened, and everything went fine.
------------------------------
Murali Krishna
RPA Consultant
------------------------------
