MS Excel Export
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-04-16 01:11 PM
I have data in a collection; and want to export to an excel workbook or sheet by creating a new excel file, and then place it a specific location.
How can I do that?
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-04-16 03:54 PM
Tried importing but the action-list does not have anything in it!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-04-16 05:19 PM
The standard MS Excel VBO ships with the product and can be found in the Blue Prism installation folder in a sub folder called 'VBO'.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-04-16 05:24 PM
If you edit the object you can see that all the flow is on the initialise page. If you create a new page within the object and move the flow, then you can publish it.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-04-16 05:40 PM
Import this xml as a object and try.
7a70be75-f30b-412b-a937-1c7b8e899eb3
Application
unknown
False
0
0
1
Clean Up
0
0
1
Action 1
0
48
1
15
-105
60
30
009c91f7-5c06-4a70-8ba7-04d99e6c9c9f
15
90
60
30
-195
-105
150
90
System.Data.dll
System.Xml.dll
System.Drawing.dll
System
System.Drawing
visualbasic
c7433130-ab70-4dd6-b653-a5309a6757f4
-195
-105
150
90
c7433130-ab70-4dd6-b653-a5309a6757f4
15
-105
60
30
39153202-d92f-4e84-93ac-1483cbc51d46
c7433130-ab70-4dd6-b653-a5309a6757f4
15
90
60
30
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
-195
-105
150
90
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
-135
60
30
ec27b536-0274-40ea-af1c-2312b63beb7f
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
225
60
30
c7433130-ab70-4dd6-b653-a5309a6757f4
Clean Up Page
This is an optional page where you might choose to perform some finalisation (or ""cleanup"") tasks as your business object is closed down.
The cleanup action will be called automatically immediately after closing your business object at the end of a business process.
You will not be able to call this action from a business process, nor will it be called at any other time than before the disposal of the business object.
-180
60
180
230
Initialise Page
This is an optional page where you might choose to perform some initialisation tasks after your business object is loaded.
The initialise action will be called automatically immediately after loading your business object.
You will not be able to call this action from a business process, nor will it be called at any other time than after the creation of the object.
-180
60
180
230
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
255
-105
60
30
collection
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
-75
90
30
638a1e89-39dd-4cc5-99ad-37e42a539686
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
45
60
30
a00e1704-fc66-465f-b0da-68f740f5779b
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
-15
60
30
0ced375e-04c4-48f4-831e-a83149187ef0
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
180
-30
60
30
text
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
90
60
30
bd2bfdb2-7b00-49f5-9479-432b200a1252
9a137ba5-7ae7-43fe-8523-d4aac0cbb883
15
150
60
30
88a64f3a-bd83-4209-bdb5-0ae22f27d3b3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
30-03-17 07:48 PM
Hello!
Did you manage to solve the issue with exporting a collection to excel?
Many thanks!
Regards,
Fredrik
