cancel
Showing results for 
Search instead for 
Did you mean: 

MS Excel Export

TathagatVerma
Level 3
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

TathagatVerma
Level 3
Tried importing but the action-list does not have anything in it!

SamanthaShaw
Staff
Staff
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'.

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.

psagar
Level 3
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

f_persson
Level 2
Hello! Did you manage to solve the issue with exporting a collection to excel? Many thanks! Regards, Fredrik